The best approach is to unpivot all your sales column into one column then it is easy. If you need a DAX solution then add the following column to your table.

I have some data and I want to sum 'Translated Ampount' based on 'revenue Category' column and then be able to map it with the customer.

I tried sumx but i have error that says - The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

I am trying to create 3 calculated columns that show in every row the total sum of specific rows in the same table, at the same time, avoid circular ...

I'm trying to find a way to SUM a column if another "column A" in the same table has a specific value OR "column B" in the same table has a specific value.

29 авг. 2022 г. · I want to return a new table using GROUPBY function that group [Week Number] and [Year] into a single row and sum the total value of column [Required Hours] ...

I'm trying to figure out how to get a measure to sum a column based on a selected value. Here's what I've got so far: 1) Created a table with possible ...

I currently have 36 columns each containing a weeks demand. I have used a paramater containing the first 9 weeks as an example and a static 36 week sum total.

Solved: Hi everyone, I need to know how to calculate the total sum of a column (sales) , so I can calculate the percentage of share sales considering.

6 апр. 2022 г. · I am trying to build a function that allows me to assign a given number to a day of the week and then add those amounts between two dates that can be selected ...