How to create if then statement in Power Query based on Error in value across three columns?

[Anonymous]

I have three columns all with dates in the them, but some of the dates of 'Error'. I want to create a new column that takes the first value that doesn't have an 'Error'.

I can get this to work in excel with this formula: =IFERROR(A1,IFERROR(B1,C1)) what is the equivalent formula for Power Query?

See screen shot for example. The green check marks are the values I'm trying to get into one column

[az38]

 Hi @Anonymous 

use "Replace Error" option. rigth-click to data column and replace error values to "0"

then use statement like

= if [Clean Date 2] = 0 then [Clean Date 3] else if .. then ... else ...

[Tad17 · Accepted solution]

Hey @Anonymous 

You can use try/otherwise as shown in this thread: https://community.powerbi.com/t5/Desktop/Power-Query-M-code-equivalent-to-quot-iferror-quot-function/td-p/281479

You can follow the guidelines in this article: https://www.poweredsolutions.co/2019/06/18/error-handling-iferror-in-power-bi-power-query/

You can use the Find & replace in the Query Editer in Power BI which will add a step to the query to replace errors with a string of your choosing.

Or you can use a calculated column with the IFERROR function: https://docs.microsoft.com/en-us/dax/iferror-function-dax

If this helps please kudo.

If this solves your problem please accept it as a solution.