Forum Discussion

Beyondforce's avatar
Beyondforce
Helper I
9 years ago
Solved

IF statment doesn't work!

Hey Guys,   I'm trying to add a new column and I'm also adding this formula, but it's not working! What's wrong with it? =IF([LateStart]= 0, && ([LateEnd] = 0),0))   Thanks. Ben.
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Beyondforce There are two parts to the Power BI Desktop. The screenshot you posted shows that you are in "Edit Queries" - this utilizes the "M" language - and that solution was provided by Vvelarde because he was smart enough to ask where you were trying this :) Once you "Close & Apply" then you are loading the data into the Tabular model front end. From here on out you need to use the "DAX" language when building measures or calculated columns. My solution works as a calculated column in DAX.

As you move back and forth between each area, just keep in mind the language changes.

 

Hope this helps out as you move forward!

Beyondforce's avatar
Beyondforce
Helper I
9 years ago

Thanks Anonymous.

 

I have just started working and playing with Power BI and I still need to learn the differnces between M language and DAX, and when to use what!

I will try your idea as well as soon as I figure out where to put the code ;)