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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
emma313823
Helper IV
Helper IV

How to do an if then

Hi All,

I have a scenario I need help with. In my data I have a column called distributor. There can be many distributor names - like Arrow, Digi-Key, Master, etc. and there are blanks. The blanks mean there are no distributors involved. In a new column, I want to say to say something like this...

 

If distributor column has data, then call it POS. and If cell is blank, call it OEM.

 

When done, I want the new column I created to show any line that has a distributor name to show as POS and any blank cell will show as OEM. In the desktop app, I have multiple tables, but am using Billings. The column will be called OEM/POS

 

emma313823_0-1623940895742.png

Is there a way to phrase this and make that happen?

 

Thanks

Emma

Emma
1 ACCEPTED SOLUTION
selimovd
Super User
Super User

Hey @emma313823 ,

 

you can do that with a calculated column and the following code:

OEM POS = IF(Billing[distributor] <> BLANK(), "POS", "OEM")

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

1 REPLY 1
selimovd
Super User
Super User

Hey @emma313823 ,

 

you can do that with a calculated column and the following code:

OEM POS = IF(Billing[distributor] <> BLANK(), "POS", "OEM")

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.