Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

  • 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