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
pjpkumar26
New Member

Power Bi Query

Hi Team,

How to create a condition on text field 

I got a field "Harm" and the values are :

Harm

A

B

C

D

 

i am trying to create a condition like 

if (Harm =A then "nom",Harm =B,"pol" else Harm)

 

what is the best way to do this in Power query please?

Thanks,

Kumar

1 ACCEPTED SOLUTION
jgeddes
Super User
Super User

If you are trying to replace the values in the original column you can add the following code to your query...

Table.ReplaceValue(previousTableStep,each [Harm],each if [Harm] = "A" then "nom" else if [Harm] = "B" then "pol" else [Harm],Replacer.ReplaceText,{"Harm"})

jgeddes_0-1727182379394.png

If you want a new column then use the 'Conditional Column' button on the 'Add Column' ribbon.

jgeddes_1-1727182483207.pngjgeddes_2-1727182500282.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

2 REPLIES 2
Omid_Motamedise
Super User
Super User

It is true, just put the column name inside [] like

 

if [Harm]="" ,,,,,,,,

 

so go to the transform tab and pick add new column and start to write your formula in the bellow syntax

 

 

if ......... then ................ else ........................

If my answer helped solve your issue, please consider marking it as the accepted solution. It helps others in the community find answers faster—and keeps the community growing stronger!
You can also check out my YouTube channel for tutorials, tips, and real-world solutions in Power Query with the following link
https://youtube.com/@omidbi?si=96Bo-ZsSwOx0Z36h
jgeddes
Super User
Super User

If you are trying to replace the values in the original column you can add the following code to your query...

Table.ReplaceValue(previousTableStep,each [Harm],each if [Harm] = "A" then "nom" else if [Harm] = "B" then "pol" else [Harm],Replacer.ReplaceText,{"Harm"})

jgeddes_0-1727182379394.png

If you want a new column then use the 'Conditional Column' button on the 'Add Column' ribbon.

jgeddes_1-1727182483207.pngjgeddes_2-1727182500282.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





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.