Forum Discussion
ORDERBY Function not Working in newest update
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.
Hi there Anonymous
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
2 Replies
- OwenAuger
Super User
Hi there Anonymous
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