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.
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.
Thanks for this! I think it works & gives me what I need. I can't confirm as it has identified an issue in my source data. Once I get that corrected, I believe this will give me exactly what I'm looking for. SO much appreciated, thank you!!!