Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Can I use a variable inside Table.ReplaceValue function ?
/#"Replaced Value32" = Table.ReplaceValue(#"Changed Type2","noFullApplicationNameTag",Text.From([meterCategory]),Replacer.ReplaceValue,{"custom_TagsFullApplicationName"})
note : i dont want to use if else query and create a new variable in the process
I need to check for a value in a field and replace the value using anothe field value in the same viariable itself.
Any idea how to do it ?
Solved! Go to Solution.
Hi @agkolkata ,
Please see code below where I added "each" to 2nd and 3rd arguments:
Table.ReplaceValue(
#"Changed Type2",
each "noFullApplicationNameTag",
each Text.From([meterCategory]),
Replacer.ReplaceValue,
{"custom_TagsFullApplicationName"}
)
Regards
KT
worked seamlessly 🙂 thanks mate
Hi @agkolkata ,
Please see code below where I added "each" to 2nd and 3rd arguments:
Table.ReplaceValue(
#"Changed Type2",
each "noFullApplicationNameTag",
each Text.From([meterCategory]),
Replacer.ReplaceValue,
{"custom_TagsFullApplicationName"}
)
Regards
KT
Addon question:
Can we use a combination of 2 variables and a fixed text as the replacement value in this ?
Hi @agkolkata ,
Yes, you can, but you in to add a conditional statement.
I have a video explain the Table.ReplaceValue function.
Regards
KT
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.