Forum Discussion

Aaron_Realms's avatar
Aaron_Realms
Regular Visitor
3 years ago

Calculated column - Latest Date

Hi All

 

Wondering if you could please help, I have a table called AllPages with a column titled Reportdate which is a date field. How do I create a calulated column that finds the max date of all items in that column and sets any row that matches that date to 'Latest'

 

Thanks

 

Aaron

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Aaron_Realms ,

     

    If ([Date], Max(Table[Date]), "Latest", [Date] & "")

     

    or

     

    If ([Date], MaxX({Table[Date], Table2[Date2], Table2[Date2]}, [Value]), "Latest", [Date] & "")

     

  • Aaron_Realms's avatar
    Aaron_Realms
    Regular Visitor
    3 years ago

    Thanks for the reply mate. Getting this error when trying to use the fromula in a custom column.

     

    Expression.Error: The name 'If' wasn't recognized. Make sure it's spelled correctly.

     

    Is that the wrong method to create a conditional column?