Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DATEDIFF With Month Filter

Hello my colleagues!   My problem is:   I need to calculate the time difference between dates, starting at 06/01/2020 and ending at "NOW". However, I need this calculation to respect the hour li...
AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
6 years ago

Here is a general pattern for running total calculations:

Running Total = 
VAR MaxDateInFilterContext =
    MAX ( Dates[Date] )
VAR MaxYear =
    YEAR ( MaxDateInFilterContext )
VAR DatesLessThanMaxDate =
    FILTER (
        ALL ( Dates[Date], Dates[Calendar Year Number] ),
        Dates[Date] <= MaxDateInFilterContext
            && Dates[Calendar Year Number] = MaxYear
    )
VAR Result =
    CALCULATE (
        [Total Sales],
        DatesLessThanMaxDate
    )
RETURN
    Result
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello Antriksh Sharma!

 

Could you explain me the steps of this calculation?