cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
kitoh1 Frequent Visitor
Frequent Visitor

Reducing the decimal places after concatenating a text & numeric field

Hi, 

 

I have a field column decimal numbers (e.g 8.78954) & a column containing a text value (e.g. M), I have concatenanted the two columns, however, I am getting multiple decimal places e.g. 8.78954M. 

 

I realise the difficulty is due to the 'Concat' column being a text field but is there anyway to reduce the decimal places to two? This is a requirement for my report

 

Thanks 

 

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisMendoza Senior Member
Senior Member

Re: Reducing the decimal places after concatenating a text & numeric field

@kitoh1 -

Would this work for you?

Column =
VAR roundDecimal =
    ROUND ( TableName[Column1], 2 )
RETURN
    CONCATENATE ( roundDecimal, TableName[Column2] )

View solution in original post

3 REPLIES 3
ChrisMendoza Senior Member
Senior Member

Re: Reducing the decimal places after concatenating a text & numeric field

@kitoh1 -

Would this work for you?

Column =
VAR roundDecimal =
    ROUND ( TableName[Column1], 2 )
RETURN
    CONCATENATE ( roundDecimal, TableName[Column2] )

View solution in original post

Super User
Super User

Re: Reducing the decimal places after concatenating a text & numeric field

@kitoh1 or you can use format function for you numeric field

 

 

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





kitoh1 Frequent Visitor
Frequent Visitor

Re: Reducing the decimal places after concatenating a text & numeric field

That worked perfectly, thanks for your help! 

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: 431 members 4,272 guests
Please welcome our newest community members: