Forum Discussion

aditi11's avatar
aditi11
Frequent Visitor
3 years ago
Solved

undefined

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

    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/

ValtteriN's avatar
ValtteriN
Community Champion
3 years ago

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/