How to round up a calculated measure?

[Anonymous]

I am calculating sales for this day vs last day. I want to calculate the percentage in change. So, I created a the following measure :

Change = ((([Total Sales] - [Total Sales Last Day])/[Total Sales Last Day])*100) & "%"

I want to round up the result to last 2 digits. I tried using INT and ROUND functions, but they dont work. Can anybody suggest how can i round up the value?

[v-yuta-msft · Accepted solution]

Hi trisabiswas,

Based on your description, you want measure [change] to be a percentage, right?

To achieve your requirement, please use DAX formula below:

Change = ([Total Sales] - [Total Sales Last Day])/[Total Sales Last Day]

Then click on [change] and click Modeling->Format->Select Percentage->Set decimal places to 2.

The result is like below and you can refer to my sample PBIX file: https://www.dropbox.com/s/t8ndcw6rt0qcfh5/For%20trisabiswas.pbix?dl=0

Best Regards,

Jimmy Tao

[Rimple_Manni]

Hi, I have similar issue, but I want only 1 value after decimal and in my case, it's rounding up 94.96 to 95% how can I show only 94.9% ?? I used 1 decimal place under formatting tab. Please help, it's urgent!

[Anonymous]

Solved !! Thanks Jimmy 🙂