Forum Discussion
Solved
Help with a Matrix
I'm struggling to build a matrix and think I'm missing something simple. I'm pulling monthly data, I have Feb. Mar. Apr. but only want to show Apr. and the year to date totals. Simply filter out th...
Great! For the cumulative total to reset, you can use the TOTALYTD() DAX function. Here's a link to the updated .pbix with both the cumulative and ytd measures. I have updated the data model to include a proper date dimension.
Hi James,
It looks like you need to create a cumulative total DAX measure. Here's a sample .pbix file.
Excellent, thank you, I'll give it a shot & let you know! Much appreciated, thank you!