ORDERBY Function not Working in newest update

[cjones875]

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.

[OwenAuger · Accepted 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

[cjones875]

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