Forum Discussion

adieball's avatar
adieball
Icon for Helper I rankHelper I
8 years ago
Solved

Latest Date based on multiple columns

Hi   I have a source that has multiple date columns. I need to find the latest date over all e.g. three columns.   How can I do this? any help is appreciated thanks
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    adieball

     

    Also using the Query Editor's User Interface,,, you can add a column for latest date

    Select all the Date Columns and select Latest date as shown in image below

     

jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
8 years ago

Make a measure to find the latest in each of the columns individually. Then make a measure that pulls the individual measure results in as variables, having a result of the latest of the three variables.