Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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.
@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 Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
21 | |
19 | |
12 | |
10 | |
9 |
User | Count |
---|---|
30 | |
26 | |
15 | |
13 | |
10 |