Split column containing 3 dates and find max date

[Anonymous]

Hi all,

I am a PowerBI newbie so please direct me to the correct forum if this question does not belong here.

I have a column called FromDate with the below content -

FromDate
2020-06-18T00:00:00
2020-01-31T00:00:00;2022-03-23T00:00:00;2020-11-17T00:00:00
2020-02-03T00:00:00;2021-04-12T00:00:00

I am looking to find the max date for this column. Any help is greatly appreciated.

Kind Regards,

R

[jameszhang0805 · Accepted solution]

1st Step : Split column by separator ; in Power Query , then add index column .

2nd Step : unpivot the table

3rd Step : Wirte Dax code like below