Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
57 | |
21 | |
21 | |
19 | |
16 |
User | Count |
---|---|
86 | |
84 | |
52 | |
37 | |
23 |