Replace and Round

0 votes
How to replace my field containing commas indicating thousands and millions with commas and . indicating decimal point, how can i achieve this requirement.
May 21 in Power BI by anshuli
13 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes
Hey Anshuli,

Create a column as below,

Column = ROUND(SUBSTITUTE([COLUMN NAME],",",""),2) or INT(SUBSTITUTE([COLUMN NAME],",",""))

The above code would first convert a number with, into a number form such as 1,20,344.7354 -> 120344.7354 Then use the round function to round to n decimal point form. int function would round to its nearest number without taking value for n.
answered May 21 by anonymous
• 15,820 points

Related Questions In Power BI

0 votes
1 answer

Is government, academic and nonprofit pricing available for Power BI?

Yes, nonprofit pricing is available when purchasing ...READ MORE

answered Sep 26, 2018 in Power BI by Kalgi
• 36,920 points
35 views
0 votes
1 answer

​Embed Power BI dashboard tile and make it auto update

This feature is not currently available with ...READ MORE

answered Sep 28, 2018 in Power BI by Kalgi
• 36,920 points
149 views
0 votes
2 answers

Send dashboards and reports as automated emails on power bi

check this: https://blog.devscope.net/2018/05/30/how-to-schedule-and-s ...READ MORE

answered Mar 21 in Power BI by Bob Jenkins

reshown Mar 22 by Vardhan 1,386 views
0 votes
2 answers

Power BI Dax Multiple IF AND Statements

HI I have Column Patient 12 13 14 15 18 IN Patient=12, 13 Out ...READ MORE

answered May 22 in Power BI by VNK
4,758 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,060 points
53 views
0 votes
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 21, 2018 in Power BI by nirvana
• 3,060 points
425 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 14,080 points
74 views
0 votes
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 36,920 points
68 views
0 votes
1 answer

How to replace null values with custom values in Power BI(power query editor)?

Hi Nithin, To fill or replace the null or ...READ MORE

answered Mar 8 in Power BI by Cherukuri
• 15,820 points
813 views
0 votes
1 answer

Power BI: TopN and All Other

Hi , Create a measure to calculate rank ...READ MORE

answered Mar 18 in Power BI by Cherukuri
• 15,820 points
159 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.