Forum Discussion

jvargas1971's avatar
jvargas1971
Frequent Visitor
3 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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's avatar
jvargas1971
Frequent Visitor
3 years ago

Thank you it is still not working. 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.