Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I create the custom column below:
When I try to sort the column "Market" by the custom column "Market sort" I get the error:
Any idea how to solve this issue?
Solved! Go to Solution.
Yes - put that sort column in your source data or Power Query. Avoid calculated columns. This is one of a dozen reasons why. 😊
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYes - put that sort column in your source data or Power Query. Avoid calculated columns. This is one of a dozen reasons why. 😊
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingI did in Power query and worked!
thank you!
Excellent @Anonymous - glad I was able to assist.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |