Forum Discussion
Anonymous
5 years agoNot applicable
Split column containing 3 dates and find max date
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
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
1 Reply
- jameszhang0805Resolver IV
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