Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Stop running total at current date

Hi,   I have found some topics covering this, however it still does not work in my report   In the picture below you can see the formula I use and how the line chart still shows values until Dece...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-yuta-msft

 

Tanks for your reply

 

The measure shows the value in that month and not the desired cummulative value.

 

joonasjaspi's avatar
joonasjaspi
Frequent Visitor
8 years ago

You could add YTD flag column to your calendar table like this:

 

 "Future";if([Date]>=NOW();1;0);

 

Then use it as visual level filter. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi joonasjaspi

     

    I already have a relative date filter on past 2 years including today for the whole report.

    So I am already using a date filter, however it still shows the running total until December.