Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

custom index for column

Hello   I am in need of a little help. I have a data sheet wich describes 1600 different objects (1 object per row). Each object has a different logical ID (such as: A-01-01-01, A-01-01-02 etc...)....
Need Help
rubayatyasmin's avatar
rubayatyasmin
Icon for Community Champion rankCommunity Champion
2 years ago

Hi, Anonymous 

 

You can use DAX RANKX() func to achieve you goal. 

 

refer: https://learn.microsoft.com/en-us/dax/rankx-function-dax

 

sample DAX idea:

 

Custom Index = 
VAR CurrentLogicalID = [Logical ID]
VAR CurrentDynamic = [Dynamic]
VAR StaticCount = COUNTROWS(FILTER(YourTable, YourTable[Dynamic] = "False"))
RETURN
IF(CurrentDynamic = "False", "False", StaticCount + RANKX(FILTER(YourTable, YourTable[Dynamic] = "True"), [Logical ID], , ASC) + 5)

 

also I found some thread that would help you give idea,

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Expression-to-create-dynamic-Index-column-to-show-all/m-p/2651611

 

https://community.fabric.microsoft.com/t5/Power-Query/Create-a-dynamic-index-column-based-on-Date-Selection-by-user/td-p/2711513

 

https://community.fabric.microsoft.com/t5/Power-Query/To-create-a-DYNAMIC-index-column-using-DAX-based-on-Rank-column/td-p/2032294