Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am creating a new report and trying to use the OFFSET function which I have done many times in the past. After I recently updated to the new May 2023 update, the ORDERBY function within the OFFSET function is not working. It would not let me use a column to order by unless I aggragated it. I loaded up the same report in an old version and the ORBERBY worked just fine. Anyone else having similar troubles.
Solved! Go to Solution.
Hi there @cjones875
I'm not sure if this is exactly what you've experienced, but I can see a glitch when first authoring a measure in Power BI Desktop. Intellisense at first does not suggest column references within ORDERBY, and then underlines themas a syntax errors.
However, the measure seems to produce the expected result, and the Intellisense seems to work correctly when I go back and edit the measure.
Is this what you're experiencing or is ORDERBY not working at all when provided column references?
Could you attach a sample PBIX (link to OneDrive or Google Drive etc) that exhibits the problem?
Regards
Hi there @cjones875
I'm not sure if this is exactly what you've experienced, but I can see a glitch when first authoring a measure in Power BI Desktop. Intellisense at first does not suggest column references within ORDERBY, and then underlines themas a syntax errors.
However, the measure seems to produce the expected result, and the Intellisense seems to work correctly when I go back and edit the measure.
Is this what you're experiencing or is ORDERBY not working at all when provided column references?
Could you attach a sample PBIX (link to OneDrive or Google Drive etc) that exhibits the problem?
Regards
I guess you're the magic man! I was even typing in the column name into the ORDERBY function when I submitted this post but was getting an error saying it couldn't even find the column. I tried again today and it seems to work!
Thanks
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |