Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts
having some trouble sorting my data out using the index against the datetime column. it may appear to be correct but if you look at the date time values cearfully they are out of sink.
Hi @Anonymous ,
Can you describe in detail your problem you're having ? Or tell me the result you want?
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Community Support - i want the datetime column to be sorted as per the index column based on datetime column. so all the data points are in the correct order. if you scroll down the datetime column you can see that further down we have 20/11/2022 01:00:00 when they all should be all together.
maybe so Column = RANKX(ALL(Sheet1),'Sheet1'[CalculationTimeUTC],,ASC)
Hi Ahmedx - try it and see if you can sort the datetime column please.
You have duplicates in the column CalculationTimeUTC , you need to remove them. and then in power queue sort and create an index column
Please check attached pbix for more details
The dups need to remain as they are real data points in the datetime timeline plot...
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |