topic Re: Convert an Excel Formula into Dax or Calculation for Power BI in DAX Commands and Tips

Convert an Excel Formula into Dax or Calculation for Power BI

jvargas1971 — Thu, 19 Jan 2023 22:57:51 GMT

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 — Fri, 20 Jan 2023 02:32:17 GMT

jvargas1971 , same will work in power bi as new column

rounddown([A],2)

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

You have to use column name

jvargas1971 — Fri, 20 Jan 2023 13:18:40 GMT

Thank you it is still not working.

Anonymous — Mon, 23 Jan 2023 09:49:09 GMT

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

You can use Try... Otherwise.

For reference:

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.