Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have some data fields in my dataset which I want to sort in an order.
I have created a calulated column for that but its giving me an error.
any help here?
Segments needed to sort:
Calculated column created:
While sorting getting this error
Solved! Go to Solution.
I created a custom table and then using Merge Queries got the desired result.
Thanks for the update though.
Regards
You cannot add calculated column for sorting using the same column that we need to sort. You would need to add the sorting column in the backend (datasource or power query) or can create calculated column not using the particular column (here, MARKET_SEGMENT).
I created a custom table and then using Merge Queries got the desired result.
Thanks for the update though.
Regards
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |