Forum Discussion

FSyed's avatar
FSyed
Regular Visitor
4 years ago
Solved

Derive the Values using Group or Rank

Hi Can someone please assist me how to derive the value for Column "CC_Derive" using the following example     Happy to provide the sample data file but not sure how and I can't see the optio...
Need Help
  • FSyed's avatar
    FSyed
    4 years ago

    Hi Alex, 

    Thanks for your help appreciate that,  its kind of working but I need to resolve using DAX funtion I guess

    After few attempts i think its workingfine 

    I have use teh following steps:

     

    Output Example

     

FSyed's avatar
FSyed
Regular Visitor
4 years ago

Hi Alex, 

Thanks for your help appreciate that,  its kind of working but I need to resolve using DAX funtion I guess

After few attempts i think its workingfine 

I have use teh following steps:

 

Output Example