Forum Discussion
Running total in matrix with dynamic switch condition
leahYan - Extremely difficult to follow. If I am reading this correctly, I am thinking this is what you need: https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428
But, I could be majorly off. But, it looks like you are fighting with a matrix and that is a way to specifically control a matrix.
Hi Greg_Deckler,
Thank you for your reply, but I am afraid that's not the issue. The issue is when a month has no data in Acc or Com, the running total of Acc or Com is blank too, which is expecting to show the same value of the previous month.
I read other solutions for missing values in the running total, and most of them can be solved by refer to a continuous date column in the calendar table instead of the date column in the fact table.
I applied that in my data model, but it couldn't solve my problem.
thank you very much.
