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 keep getting Token EOF error messages, even when I try a much simpler formula. What is the problem I'm creating for myself?
Solved! Go to Solution.
DAX uses a different syntax. IF(<condition>,<do if true>,<do if false>)
Note: In Power Query commands are case sensitive. There use if ... then ... else
DAX uses a different syntax. IF(<condition>,<do if true>,<do if false>)
Note: In Power Query commands are case sensitive. There use if ... then ... else
OK, thanks. Now I see the mistake I was making, i completely missed that I needed an "else" there to close it out.
In DAX you can get away with not specifying the "else" part - it will return BLANK() for you. In Power Query "else" is mandatory.
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.