Dear Community,
Good Day.
Please have a look on this pbix: https://ufile.io/5uxflmsc
In this pbix, i have the data for 2 year and comparing to the particular month when month slicer is selected.
I would like to create another new matrix table which is similar to this attached picture but is in Cumulative form.
For example, when month slicer is selected 'March'. The cumulative table will sum up January,February and March data for Consol#, Shipment# and Chargeable of the year.
I have tried to referred many DAX solutions but all of it does not works for me.
Appreciate any helps provided.
Hi @NickProp28 ,
Crreste the following measure:
Consol= TOTALYTD( count(ConsolShipment[Consol ID]);'Calendar'[Date])
Now you just need to do the same measure for the rest of the columns you need:
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @NickProp28 ,
Crreste the following measure:
Consol= TOTALYTD( count(ConsolShipment[Consol ID]);'Calendar'[Date])
Now you just need to do the same measure for the rest of the columns you need:
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
