Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Visual Calculation RunningSum OrderBY not using Sort by Column

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 = 1
test = RUNNINGSUM([Number 1], ORDERBY([Month], ASC))

vicky__0-1764651176612.png

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. 

Status: New