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

I have used following function (New Column) to derive the Flag values and Max_Amount

col_Flag_999_998=
var var1 = tbl_Distinct_Employee_CC[CostCentre]
RETURN
If(OR (var1 = 498650, var1 = 498655) , 1 ,BLANK())