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
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors