Forum Discussion
Round Up values in a Matrix Values Section
Hi All,
I created a matrix as below with using below table. however values need to be rounded up next integer.
A should be 7 instead of 6.20 and B should be 1 instead of 0.20. even I create a new column and round up "paid table" result is going to be 8 for A and 2 for B and it will be much far away than expected.
tablecreated matrix
selpaqm
Let's say you have a Measure to calculate the total amount. You can use Amount =Roundup(Sum(Table[Amount]),0)If you are satisfied with my answer, please mark it as a solution so others can easily find it.
Don't forget to give KUDOS ? to replies that help answer your questions
Subscribe to ExcelFort: Learn Power BI, Power Query and Excel
5 Replies
selpaqm
This function should help you:
https://docs.microsoft.com/en-us/dax/roundup-function-dax#:~:text=If%20num_digits%20is%200%2C%20then,always%20rounds%20a%20number%20up.If you are satisfied with my answer, please mark it as a solution so others can easily find it.
Don't forget to give KUDOS ? to replies that help answer your questions
Subscribe to ExcelFort: Learn Power BI, Power Query and Excelselpaqm
Let's say you have a Measure to calculate the total amount. You can use Amount =Roundup(Sum(Table[Amount]),0)If you are satisfied with my answer, please mark it as a solution so others can easily find it.
Don't forget to give KUDOS ? to replies that help answer your questions
Subscribe to ExcelFort: Learn Power BI, Power Query and Excel
