Forum Discussion
Solved
Running total missing values
Hi, I'm facing an unusual issue that I'm not able to solve. I've created a running total on a table that which increment every year. In the same project I've also a counter for every yea which ...
Hi,
This pattern should work
- Create a Calendar Table with a calculated column formula to extract the Year
- Create a relationship (Many to One and Single) from the Date column of the Data Table to the Date column of the Calendar Table
- To your visual, drag Year from the Calendar Table
- Write these measures
Count = CALCULATE(SUM(Table[Counter]),Table[Type]="TYPE1")
Running count = calculate([count],datesbetween(calendar[date],minx(all(calendar),calendar[date]),max(calendar[date])))
Hope this helps.
Hi,
many thanks, the proposed solution worked perfectly.
In ordet to better understanding, could you provide some more detail for the usage of Datesbetween and minx ?
Thanks again
You are welcome. Please read up on these yourself.