Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I want to conditionally replace a Field column value based on a IF statement on other column.
For some reason i couldnt get it to work, which i later found out has to do with a empty value in the target colum.
Test case with a blank Power BI document:
Create a Table using Data Entry with this format:
Code Reference
HSPAHAPAN VW
HSPHAPAN (notice a empty field for Reference)
HAMUMC VW003570
So the Reference fields are wrong for 2 rows are Wrong. If Code == HSPHAPAN then Reference should be VW003569
So I used thise code for transformation:
= Table.ReplaceValue(
#"Waarde vervangen",
each [Reference], //old field value
each if [Code] = "HSPHAPAN" then "VW003569" else [Reference] , // new field value based on IF statement on different Column. If no Match, use the old field value
Replacer.ReplaceText,{"Reference"})
This only work for the HSPHAPAN rows with some content in the Reference field! So result became:
Code Reference
HSPHAPAN VW003569 (The VW transformed into VW003569, correct)
HSPHAPAN (nothing is done here, wrong!)
HAMUMC VW003570 (Data is untouched, correct)
I'm rather new to Power BI / M / Dax, so maybe i'm missing something?
Solved! Go to Solution.
Your code is correct. Just change Replacer.ReplaceText to Replacer.ReplaceValue
Hmm really had the idea, i used both options without getting the correct results. But now seems correct with ReplaceValue! Thanks
Your code is correct. Just change Replacer.ReplaceText to Replacer.ReplaceValue
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.