Forum Discussion
Convert an Excel Formula into Dax or Calculation for Power BI
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.
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
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
Thank you it is still not working.
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
