Forum Discussion
Helper ITotal per month in column
Hi, I have a data that I want to get the total per month but i want it to be in column. how can i make it in tabular format in visual
data:
I want the result to be like this
| Jan 2025 | Feb 2025 | |
| A | 4 | 3 |
| B | 8 | 6 |
| C | 12 | 10 |
Try this ....
Use Power Query to edit the query table.
Right click on teh date column and left click, on "Unpivot Other Columns".
It will default the ABC column to Attrobute" but you can rename it.
Save and apply the query
Add a column (or use a calenadar table)
Period = FORMAT(yourdata[Date],"YYYY MMM")
Add a matrix visual to your report
Please click the [accept solution] and thumbs up buttons.
At the very least please click the thumbs up button.
Thank you.
2 Replies
speedrampsSuper User
Try this ....
Use Power Query to edit the query table.
Right click on teh date column and left click, on "Unpivot Other Columns".
It will default the ABC column to Attrobute" but you can rename it.
Save and apply the query
Add a column (or use a calenadar table)
Period = FORMAT(yourdata[Date],"YYYY MMM")
Add a matrix visual to your report
Please click the [accept solution] and thumbs up buttons.
At the very least please click the thumbs up button.
Thank you.Hi jayceeb ,
Thanks for speedramps's reply!
DAX may not do exactly what you need, and as speedramps's reply, maybe using Power Query is the best option.
If you must use DAX, I'm afraid you will only get your desired result transposed.
Use this DAX to create a calculated table :MonthlySummary = SUMMARIZE( OriginalTable, OriginalTable[MonthYear], "A", SUM(OriginalTable[A]), "B", SUM(OriginalTable[B]), "C", SUM(OriginalTable[C]) )And the final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
