Forum Discussion
Post ProdigyFrom DAX studio to Power BI DAX code
My code works fine in Dax Studio but when I move it to Power BI I have some trouble with it. Finally, I was able to change it and make it work but now having trouble with ORDER BY. I want to order the X table by ranking. Can someone help with this please. Also why on some pages it is ORDERBY but somewhere it is ORDER BY.
https://dax.guide/st/order-by/
MY TABLE =
VAR T =
SUMMARIZECOLUMNS (
'TABLEA'[COLUMN1],
"REASON", COUNT ( 'TABLEA[COUNT] )
)
VAR X = ADDCOLUMNS (
T, "Ranking",
RANKX (
T, [REASON]
)
)
RETURN X
5 Replies
- Dangar332
Resident Rockstar
Hi, stribor45
Use below
MY TABLE =
VAR T =
SUMMARIZECOLUMNS (
'TABLEA'[COLUMN1],
"REASON", COUNT ( 'TABLEA[COUNT] )
)
VAR X = ADDCOLUMNS (
T, "Ranking",
RANKX (
T, [REASON] ,,asc
)
)
RETURN X
Use Asc or desc as your requirements
And this orderby use in window function like (offset, rank,window)
And this order by use outside of dax query to indicate order of any column or expression.
