Convert an Excel Formula into Dax or Calculation for Power BI

[jvargas1971]

Hello community, 

I use a formula in excel to roundown a number and if in case it can't then to give me whatever is there. This is for address numbers. 

IFERROR(rounddown(A1,-2),A1

I have tried a few times to make this work but I have not been able to do it. 

[amitchandak]

@jvargas1971 , same will work in power bi as new column

rounddown([A],2)

or

IFERROR( rounddown([A],2) , [A])

You have to use column name

[jvargas1971]

Thank you it is still not working. 

[Anonymous · Accepted solution]

Hi @jvargas1971 ,

According to your statement, I think you are using Power Query in Power BI.

You can use Try... Otherwise.

For reference:

Power Query M code equivalent to "iferror" function

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.