cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abartozzi Member
Member

Adjust numbers

Hi community, 

 

Have this thing to fix: I have a column of decimal values and I would like this to happen:

 

235,24 > 235

207.24 > 209

159.45 > 159

371.80 > 375

343.92 >345

 

in other words, adjusted numbers always have to finish in 5 or 9. 

 

I tried with INT or round Up but doesn't always work.

Do you know any other way?

 

thank you

Alberto

1 ACCEPTED SOLUTION

Accepted Solutions
Phil_Seamark Super Contributor
Super Contributor

Re: Adjust numbers

HI @abartozzi

 

I think I follow what you need and I think this calculated column gets close.  You can tweak the IN statement to control if you prefer Zeros to round to 5 or 9.  I have attached a PBIX file

 

Column = 
VAR BaseVar = INT('Table1'[Column1])
VAR NewEndVal = SWITCH(TRUE(),MOD(BaseVar,10) IN {0,1,2,3,4,5} , 5 , 9)
RETURN (INT(DIVIDE(BaseVar,10)) * 10) + NewEndVal

image.png


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

1 REPLY 1
Phil_Seamark Super Contributor
Super Contributor

Re: Adjust numbers

HI @abartozzi

 

I think I follow what you need and I think this calculated column gets close.  You can tweak the IN statement to control if you prefer Zeros to round to 5 or 9.  I have attached a PBIX file

 

Column = 
VAR BaseVar = INT('Table1'[Column1])
VAR NewEndVal = SWITCH(TRUE(),MOD(BaseVar,10) IN {0,1,2,3,4,5} , 5 , 9)
RETURN (INT(DIVIDE(BaseVar,10)) * 10) + NewEndVal

image.png


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 266 members 2,882 guests
Please welcome our newest community members: