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.
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")
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.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |