Forum Discussion

Sudharshan1919's avatar
Sudharshan1919
Icon for Helper III rankHelper III
4 years ago
Solved

Latest Date

Hi All,   I am having 3 region sheets like Region1, Region2 and Region3. Those files get updated on a daily basis 4-5 times per day including with the timestamp, where the data is stored in the "Da...
  • johnt75's avatar
    johnt75
    4 years ago

    Something like this should work as a calculated column

    Latest date =
VAR CurrentDate = 'Table'[Date time]
VAR MaxDate =
    CALCULATE ( MAX ( 'Table'[Date time] ), ALLEXCEPT ( 'Table', 'Table'[Region] ) )
RETURN
    IF ( CurrentDate = MaxDate, "Yes" )
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

Something like this should work as a calculated column

Latest date =
VAR CurrentDate = 'Table'[Date time]
VAR MaxDate =
    CALCULATE ( MAX ( 'Table'[Date time] ), ALLEXCEPT ( 'Table', 'Table'[Region] ) )
RETURN
    IF ( CurrentDate = MaxDate, "Yes" )