Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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?
Solved! Go to 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
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
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!
Solved !! Thanks Jimmy 🙂