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.
I am running into an issue with the formula listed below. I tried the "&&" instead of the "and" but i have the same results (error) when validating my formula.
Can you please help me manage this?
Solved! Go to Solution.
Hi @Anonymous
This is MCODE in Power Query, and it's not Dax to use &&.
https://docs.microsoft.com/en-us/powerquery-m/m-spec-conditionals
Don't use else for all IF statements; write IF then else IF then else IF then else ,,,
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!
@Anonymous In the Power Query language M you have to use only one ampersand -> &
It works?
B.
it was not that the problem but the if clause.
Hi @Anonymous
This is MCODE in Power Query, and it's not Dax to use &&.
https://docs.microsoft.com/en-us/powerquery-m/m-spec-conditionals
Don't use else for all IF statements; write IF then else IF then else IF then else ,,,
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!
Thank you. It works
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |