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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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