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 December.

 

Hope you can help me

Need Help

5 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi Guidoow1,

     

    Modify you measure like pattern below and check if it can meet your requirement:

    Marge running total in Month =
CALCULATE (
    SUM ( 'Transactiewaarde'[Marge] ),
    FILTER (
        SUMMARIZE ( 'Kalendar', 'kalendar'[Date].[MonthNo], 'kalendar'[Date].[Month] ),
        ISONORAFTER (
                Kalendar[Date].[MonthNo], MAX ( Kalendar[Date].[MonthNo] ), DESC,
                Kalendar[Date].[Month], MAX ( Kalendar[Date].[Month] ), DESC
        )
    ),
    ALLSELECTED ( 'Kalendar' )
)

    Regards,

    Jimmy Tao

    • 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.