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.
Hello,
Im trying to add a custom column that taked 2 conditions from 2 different colums in the same table.
I tried using IF function but it returns this error "Expression.Error: The name 'IF' wasn't recognized. Make sure it's spelled correctly."
This is what i tried -
IF([Event]="X" & [EventName]="Y",0,1)
The reason is to be able to sum up the colum with edit query.
Thanks!
Solved! Go to Solution.
Hi @Anonymous
if is lower case in Power Query.
What you need is
if [Event] = "X" and [Eventname] = "Y" then 0 else 1
Regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
@Anonymous , Try &&
IF([Event]="X" && [EventName]="Y",0,1)
Hi @Anonymous
if is lower case in Power Query.
What you need is
if [Event] = "X" and [Eventname] = "Y" then 0 else 1
Regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
Hi!
Thanks a lot, that did the trick.
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |