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 Champ's
I am new to PBI, wondering if someone can help me with below query,
i have a note field with general text, and i want to create a new column with
if note field contains both "enquiry" and "OBG" then "A"
if note field contains "enquiry" NOT "OBG" then "B"
else "C"
whats the best way to do this?
Ash
Hi,
Try this calculated column formula
=IF(SEARCH("Enquiry",Data[Note],-1)>0,IF(SEARCH("OBG",Data[Note],-1)>0,"A","B"),"C")
Hope this helps.
Not sure what is wrong, getting an error message
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 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |