This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
Hello,
There's a bug with using the ORDERBY() parameter with a column sorted by another column. To recreate this issue, I created a Date Table with a column for the month name, and a measure called Number 1, and a visual calculation called test. [Month] in the Date table is sorted by [Month Sort].
Date = ADDCOLUMNS(CALENDARAUTO(),
"MonthSort", FORMAT([Date], "yyyymm"),
"Month", FORMAT([Date], "mmm yyyy"))Number 1 = 1test = RUNNINGSUM([Number 1], ORDERBY([Month], ASC))
As seen in the screenshot, the [test] visual calculation is ordering by the literal [Month], rather than the underlying [Month Sort] column. If I use the [Month Sort] column instead of [Month], then it works perfectly fine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.