Sort by Column bug

[Greg_Deckler]

Steps to recreate:

1. Create a table: Calendar = CALENDAR(DATE(2019,1,1), DATE(2019,12,31))
2. Create two columns in table: Appples = RANDBETWEEN(1,4), Pears = RANDBETWEEN(0,3)
3. Create third column: Column = (DATE(2019,12,31) - [Date]) * 1.
4. Set Sort By column for Date column to Apples column
5. Column contains all errors (#ERROR)

In fact, any change to the Sort By column for Date will cause Column to error out

[v-qiuyu-msft]

Hi @Greg_Deckler, 

I have reported this issue internally: CRI 165069754. Will update here once I get any information. 

Best Regards,
Qiuyun Yu

[v-qiuyu-msft]

Hi @Greg_Deckler, 

PG team are working on the issue. Currently you can try the workaround below: 

Make minor changes like adding a space in the calculated column expression and save it - it will force a recalc in the model.

Best Regards,
Qiuyun Yu

[mepk56]

Any solution available yet?