Forum Discussion

lbrown's avatar
lbrown
Helper I
8 years ago
Solved

How Do I Write This IF Error Statement in Power Query & Power BI Desktop

I have the following formula in an excel sheet =IFERROR(IF(V2="",0,IF(W2<>"",W2-T2,Lookups!$L$1-T2)),0) and it does a vlookup to another tab with the prior date. In Power Query I now have a column th...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI lbrown,

     

    You can take a look at below links about error handling in dax and m query:

    Error-handling in Power Query

    IFERROR Function (DAX)

     

    For your measure, it can be transform as below measure:

    Result =
VAR prior = xxxx
VAR V2 = xxx
VAR W2 = xxx
VAR T2 = xxx
RETURN
    IFERROR ( IF ( V2 = "", 0, IF ( W2 <> "", W2 - T2, prior - T2 ) ), 0 )

    I'm not clear how you get these variables, so I use var function to define them as variables .

     

    Regards,

    Xiaoxin Sheng

lbrown's avatar
lbrown
Helper I
8 years ago

Hi Anonymous

 

I checked out the links. I'm not quite sure what you mean by the variables andthe var function to define the variables. I entered the formula below into Power Query Editor and received error message:

 

Expression.Error: The name 'iferror' wasn't recognized.  Make sure it's spelled correctly.

 

Formula I entered in Power Query Editor: 

=iferror( IF ( [CONFIRMED_START_DATE] = "", 0, IF ( [CONFIRMED_DROP_DATE] <> "", [CONFIRMED_DROP_DATE] - [REQUESTED_START_DATE], [Prior Date] - [REQUESTED_START_DATE]) ), 0 )

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi lbrown,

 

My formula is dax version, it not works for power query. You also need to input variable before use it..


Regards,

Xiaoxin Sheng

  • lbrown's avatar
    lbrown
    Helper I
    8 years ago

    Hi Xiaoxin,

     

    I didn't realize your formula was the Dax version, but I used this formula and included the correct column names for the variables and this worked. Thanks for your help.

     

    Best,

    Lauren