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

     

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi adieball,

Based on my test, you could refer to below steps:

Add a customer column in query editor:

=List.Max({[Column2], [Date1], [Column1]})

Apply it and create a measure:

myMax = MAX('Table1'[Latest])

Now you could see the correct result.

 

Regards,

Daniel He

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    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