Hello team, I want to remove the decimal places from a measure. For ex. If value is 4.00 I want to display it as 4.
I have used below dax fir it. But not working.
Avg days = trunc(avg(orders[delivery days]))
Please help
Hi,
The amount of decimals displayed is a formatting setting. Check how many decimals you have here (in my example I have 0):
If you want to change this with dax use FORMAT function e.g. FORMAT([measure],"#")
This will display your number with 0 decimals.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Hi,
The amount of decimals displayed is a formatting setting. Check how many decimals you have here (in my example I have 0):
If you want to change this with dax use FORMAT function e.g. FORMAT([measure],"#")
This will display your number with 0 decimals.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
