Forum Discussion

Applicable88's avatar
Applicable88
Icon for Impactful Individual rankImpactful Individual
4 years ago
Solved

Running Total without Max(Date)

Hello,   I did try something out with the running total. Normally that is the standard running total for one sales and one date column from a mastercalendar: Measure = calculate(sum(Sales[Sales...
data protection
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    4 years ago

    Applicable88 , Please find if the split can help

     

    Filter(
    ALL('Calendar'[Date]), -- Conside all dates in the calendar
    'Calendar'[Date] // column to be compared
    <=max('Calendar'[Date]) // This is current row context -- max of that row is the value of that row.
    ))
     
    So all dates below the date in context(rows) will be selected
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Applicable88 , Please find if the split can help

 

Filter(
ALL('Calendar'[Date]), -- Conside all dates in the calendar
'Calendar'[Date] // column to be compared
<=max('Calendar'[Date]) // This is current row context -- max of that row is the value of that row.
))
 
So all dates below the date in context(rows) will be selected