Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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")
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
80 | |
64 | |
52 | |
48 |
User | Count |
---|---|
212 | |
89 | |
79 | |
68 | |
60 |