Forum Discussion

Greig_Dunbar's avatar
Greig_Dunbar
New Member
5 years ago

Date Value that Refers to all Previous Dates in Chart

 

Hello, hoping someone can help. 

 

I am looking to create a function that allows the month value displayed on a table to actually refer to all data on or before the month displayed. This is in order to simulate point in time compliance figures. 

 

For example, May 2021 would actually show all data from the end of May 2021 backwards. January 2021 would similarly show from the end of January 2021 backwards.

 

Hope this helps explain my issues 🙂

 

Thanks

dates
graphs
Point in time

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Greig_Dunbar , are you looking for cumulative?

     

    example

    Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))

     

    Cumm Sales till month back= CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=eomonth(max(date[Date]),-1) ))