Replacing ID?

Anonymous · ‎08-06-2019

The above is all one company, just split by the 'Product_Family__c' column. Payroll is always the main product family.

What I'm attempting to do is take the 'System_ID_c' value for payroll (1405) and populate it into the HRIS field which has a null. Is there any way to do that? I will need to ensure that for each company, the HRIS 'System_ID_c' field matches that of the payroll field.

parry2k · ‎08-06-2019

@Anonymous is it always 1405 for null values?

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎08-06-2019

@parry2k no it is not. For rows that will have the value 'HRIS' for the 'Product_Family_c' column, the 'System_ID_c' value will always be null. I'm trying to find some kind of way to populate the HRIS null system id value with whatever the value is for the payroll system id.

Anonymous · ‎08-06-2019

@parry2k No worries, I have figured out a solution.

Replacing ID?

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly