Forum Discussion

Helper 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

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

Microsoft Employee

8 years ago

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

Community Champion

8 years ago

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