Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |