Total per month in column

[jayceeb]

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

[Anonymous]

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.

[speedramps · Accepted solution]

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.