Forum Discussion

PowerUser39's avatar
PowerUser39
Frequent Visitor
2 years ago
Solved

DAX to Power Query - IF Statement

Hello,   I am trying to write the below DAX in Power Query's Custom Column but getting some errors and not getting intended results same as DAX.   DAX Code to calculate calendar years interval. ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    PowerUser39 OK, I don't get any errors and just one difference, is this what you are seeing as well? One thing is that I don't quite understand your DAX, you seem to have a useless IF statement in there as it returns the same thing regardless (line 4). Also, be careful with using "" as you might want to change this to null in PQ. PBIX is attached.

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

PowerUser39 OK, I don't get any errors and just one difference, is this what you are seeing as well? One thing is that I don't quite understand your DAX, you seem to have a useless IF statement in there as it returns the same thing regardless (line 4). Also, be careful with using "" as you might want to change this to null in PQ. PBIX is attached.

 

PowerUser39's avatar
PowerUser39
Frequent Visitor
2 years ago

Thanks Greg. I inserted another condition to exclude the Null value and it worked for me.