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,
In our query tool beneeth multiple if statement is made. Can some one advice how to build this in Power BI?
I am especially interested in how to code the multiple if statement (I get the message that not more than 2 are acceptable) and how to code the validation on certain text in a certain column, so the 'not like' rows in the picture.
Thanks in advance!
Solved! Go to Solution.
Hi @Hyperchef1969,
For another option, you also could have a good look at this blog Multi Condition Logic In Power Query.
Best Regards,
Cherry
Hi @Hyperchef1969,
For another option, you also could have a good look at this blog Multi Condition Logic In Power Query.
Best Regards,
Cherry
You can create a Conditional column and select begins with in Operator section in Query Editor
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |