Forum Discussion

sd22's avatar
sd22
Frequent Visitor
3 years ago
Solved

DAX - RankX Function

Hi All, Can we give a custom value in RANX function so that rank starts from a particular number instead of 1 ? I want my Rank to start from 500 instead of 1. The DAX that I'm using is  i...
Need Help
  • Payeras_BI's avatar
    Payeras_BI
    3 years ago

    Hi sd22,

    How about adding 499 to your measure?

    Regards,

     

sd22's avatar
sd22
Frequent Visitor
3 years ago

Hi All,

 

I have a column named pp having numeric values 0 till 12. This pp column is acting as a slicer. If I select any value say 5 from the pp slicer then I want to have a calculated column which will contain values 0,1,2,3,4,5 in a row wise fashion. Can anyone help me with the dax plase ?

 

Thanks & Regards

Sd22