Forum Discussion
Running Total returns wrong value
Anonymous
You need to create a calendar table with distinct dates, and connect that date column to your current created at date. Then you would use the new calendar date in the filter expression. For example, if you data is from 2020 to 2021, try1. Create a calendar table =Calendar(date(2020,11), date(2021,12,31))
2. Connect the new date table with Created_At.3. create the measure:
Measure = calculate(sum(sheet1[value]), Filter(allselected(calendar table), isonorafter(calendar table[date], max(calendar table[date]), desc))
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Anonymous
You need to create a calendar table with distinct dates, and connect that date column to your current created at date. Then you would use the new calendar date in the filter expression. For example, if you data is from 2020 to 2021, try
1. Create a calendar table =Calendar(date(2020,11), date(2021,12,31))
2. Connect the new date table with Created_At.
3. create the measure:
Measure = calculate(sum(sheet1[value]), Filter(allselected(calendar table), isonorafter(calendar table[date], max(calendar table[date]), desc))
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.