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-18...
MAX date
Split column
  • jameszhang0805's avatar
    jameszhang0805
    5 years ago

    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 

     

jameszhang0805's avatar
jameszhang0805
Icon for Resolver IV rankResolver IV
5 years ago

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