Forum Discussion
Solved
Total Per Month
Hi, I need help with creating DAX for the following: Instead of showing the value for each status per date per month, I need to show the total status per month in the desired result. thank...
Hi, JB17
Based on your information, I create a sample table:
Then unpivot columns, like this:
Select Close & Apply. Create a table visual, put the date, status, and values in the table, and then date selection to leave the month. Here is my preview:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
UnPivot all the dates column using Transfrm .
Then you Have three column status, Date, Values.generate Mobth from date aas Month
then you can you Matrx visul
Drag Column as below
Rows : STATUS
Columns :Month
Values: sum of values
Hope this helps