Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Solved! Go to Solution.
Hi @sajjadansari ,
Why not just unpivot your data table and create three columns such as Type, Month-Year, Sales. Unpivoting your data can indeed simplify your DAX calculations and make your data model more flexible. By unpivoting, you transform your wide table (with one column per month) into a long table (with one column for months and another for values). This approach can make it easier to perform time-based calculations and aggregations.
If you want to unpivot, go to power query > Select the columns for the months (e.g., Jan-24 to Dec-24) > Right-click on the selected columns and choose Unpivot Columns. > This will transform your data into a long format with columns for Attribute (month) and Value (sales amount) > Rename the Attribute column to Month-Year and the Value column to Sales > ClickClose & Apply to load the transformed data back into Power BI.
However, if you want maintain wider table, then you can try this:
Total Sales 2024 =
SUMX(
FILTER(
'Combine-YTD',
'Combine-YTD'[TYPE] = "Sales"
),
'Combine-YTD'[Jan-24] + 'Combine-YTD'[Feb-24] + 'Combine-YTD'[Mar-24] +
'Combine-YTD'[Apr-24] + 'Combine-YTD'[May-24] + 'Combine-YTD'[Jun-24] +
'Combine-YTD'[Jul-24] + 'Combine-YTD'[Aug-24] + 'Combine-YTD'[Sep-24] +
'Combine-YTD'[Oct-24] + 'Combine-YTD'[Nov-24] + 'Combine-YTD'[Dec-24]
)
Hope this helps!!
If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz
Hi @sajjadansari ,
Why not just unpivot your data table and create three columns such as Type, Month-Year, Sales. Unpivoting your data can indeed simplify your DAX calculations and make your data model more flexible. By unpivoting, you transform your wide table (with one column per month) into a long table (with one column for months and another for values). This approach can make it easier to perform time-based calculations and aggregations.
If you want to unpivot, go to power query > Select the columns for the months (e.g., Jan-24 to Dec-24) > Right-click on the selected columns and choose Unpivot Columns. > This will transform your data into a long format with columns for Attribute (month) and Value (sales amount) > Rename the Attribute column to Month-Year and the Value column to Sales > ClickClose & Apply to load the transformed data back into Power BI.
However, if you want maintain wider table, then you can try this:
Total Sales 2024 =
SUMX(
FILTER(
'Combine-YTD',
'Combine-YTD'[TYPE] = "Sales"
),
'Combine-YTD'[Jan-24] + 'Combine-YTD'[Feb-24] + 'Combine-YTD'[Mar-24] +
'Combine-YTD'[Apr-24] + 'Combine-YTD'[May-24] + 'Combine-YTD'[Jun-24] +
'Combine-YTD'[Jul-24] + 'Combine-YTD'[Aug-24] + 'Combine-YTD'[Sep-24] +
'Combine-YTD'[Oct-24] + 'Combine-YTD'[Nov-24] + 'Combine-YTD'[Dec-24]
)
Hope this helps!!
If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz
Dear Mr.
Shahariar Hafiz
i shared DAX Function to summing up multiple column, ( i am not looking solution) its already a solution.
Thanks for Understanding.
Mr.
Shahariar Hafiz
i shared Solution (DAX Function) not a Problem.
Thanks for Understanding.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |