cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FSyed
New Member

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

Issue_derive_CC.JPG 

 

Happy to provide the sample data file but not sure how and I can't see the option

 

EmpNo	Name	Amount	CC	Flag	CC_Derive
123	Mr Smith 100	4652	0	4652
123	Mr Smith 200	4659	0	4659
123	Mr Smith 300	999	1	4659
124	Mr X	400	4971	0	4971
124	Mr X	300	999	1	4971
124	Mr X	200	4834	0	4834
124	Mr X	100	4659	0	4659

 

 

1 ACCEPTED SOLUTION
FSyed
New Member

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:

Steps_Replace_ReserveCode.JPG

 

Output Example

output examplee.JPG

 

View solution in original post

3 REPLIES 3
FSyed
New Member

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:

Steps_Replace_ReserveCode.JPG

 

Output Example

output examplee.JPG

 

AlexisOlson
Super User
Super User

I think this would be easiest in the query editor.

 

FSyed
New Member

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())

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors