Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
agkolkata
Regular Visitor

Can I use  variable inside Table.ReplaceValue function ?

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 ? 

 

 

1 ACCEPTED SOLUTION
KT_Bsmart2gethe
Impactful Individual
Impactful Individual

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

 

View solution in original post

4 REPLIES 4
agkolkata
Regular Visitor

worked seamlessly 🙂 thanks mate

KT_Bsmart2gethe
Impactful Individual
Impactful Individual

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.

Table.ReplaceValue 

 

Regards

KT

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.