Forum Discussion

Dyke211's avatar
Dyke211
Helper I
2 years ago
Solved

Need Help with date difference between values within a column

HI Guys, can anyone give me a good dax measure of calculated column that shows different in the number of days between reported events within a single column such that if i slice based on Assettype, ...
  • tamerj1's avatar
    tamerj1
    2 years ago

    Hi Dyke211 

    please try

    Number of Days Diff. =
    VAR CurrentDate = 'Table'[ReportedEvent]
    VAR CurrentTypeDates =
        CALCULATETABLE (
            VALUES ( 'Table'[ReportedEvent] ),
            ALLEXCEPT ( 'Table', 'Table'[AssetType] )
        )
    VAR previousDate =
        MAXX (
            FILTER ( CurrentTypeDates, 'Table'[ReportedEvent] < CurrentDate ),
            'Table'[ReportedEvent]
        )
    RETURN

        DATEDIFF ( COALESCE ( previousDate, CurrentDate ), CurrentDate, DAY )