Forum Discussion

Jondon29's avatar
Jondon29
Frequent Visitor
7 years ago
Solved

Limiting Running Total to Today

Hello,

 

I am trying to limit my running total to today.  My current formula is below; I've tried adding a filter to limit to todays date.

 

RunningTotal Completed = SUMX(FILTER(ALLSELECTED('1 - DateTable'),'1 - DateTable'[Date]<=MAX('1 - DateTable'[Date])),[Completed])
 
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi Jondon29

     

    You mean you want to show the line only until today?

    Assuming your measure works correctly, you can do something like:

     

     

    NewMeasure =
IF ( MAX ( '1 - DateTable'[Date] ) <= TODAY (), [YourWorkingMeasure] )

     

    This returns a blank on dates after today, so that nothing will be displayed.  You could also embed this behavior in your current measure.

2 Replies

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi Jondon29

     

    You mean you want to show the line only until today?

    Assuming your measure works correctly, you can do something like:

     

     

    NewMeasure =
IF ( MAX ( '1 - DateTable'[Date] ) <= TODAY (), [YourWorkingMeasure] )

     

    This returns a blank on dates after today, so that nothing will be displayed.  You could also embed this behavior in your current measure.