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
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Power BI Monthly Update - May 2024
Check out the May 2024 Power BI update to learn about new features.
