Forum Discussion

SushmaReddy's avatar
SushmaReddy
Icon for Helper I rankHelper I
4 years ago
Solved

DAX Tip

Hi Team, I created a calculated Column using the below mentioned logic and getting correct output. C1 = RANKX(T1,CONCATENATE(T1[Processing Date],T1[Version or Model Number] &Single_Material[Status...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi SushmaReddy ,

     

    Glad to know that!😀

    please kindly Accept it as the solution to make the thread closed. More people will benefit from it.

     

    Best Regards,
    Eyelyn Qin

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi SushmaReddy ,

 

Please try to add +0 in the end to replace the blank value:

 

C1 = RANKX(T1,CONCATENATE(T1[Processing Date],T1[Version or Model Number] &Single_Material[Status]))+0

 

 

If the issue still exist, please provide more details about your table or share your pbix file after removing sensitive data to help us clarify your scenario.

 

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

How to Get Your Question Answered Quickly - Microsoft Power BI Community

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.