Forum Discussion

SushmaReddy's avatar
SushmaReddy
Helper 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 ,

 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

 

Best Regards,
Eyelyn Qin

SushmaReddy's avatar
SushmaReddy
Helper I
4 years ago

Hi Eyelyn Qin,

    I have used different logic as shown

 Processing Details =

CONCATENATE(T1[Processing Date & Time],T1[Version or Model Number] &T1[Status])
and use this logic in a Measure as shown below where i got "0" instead of "Blank".
Processing Data = DISTINCTCOUNT(T1[Processing Details])+0