Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Is there a way to phrase this and make that happen?
Thanks
Emma
Solved! Go to Solution.
Hey @emma313823 ,
you can do that with a calculated column and the following code:
OEM POS = IF(Billing[distributor] <> BLANK(), "POS", "OEM")
Hey @emma313823 ,
you can do that with a calculated column and the following code:
OEM POS = IF(Billing[distributor] <> BLANK(), "POS", "OEM")
User | Count |
---|---|
77 | |
75 | |
46 | |
31 | |
28 |
User | Count |
---|---|
99 | |
91 | |
51 | |
49 | |
46 |