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, 2019 in Power BI by anshuli
393 views

1 answer to this question.

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, 2019 by anonymous
• 33,030 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
• 52,360 points
390 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
• 52,360 points
1,474 views
+1 vote
3 answers

Send dashboards and reports as automated emails on power bi

also, check - https://bihelper.tech It is a cloud service ...READ MORE

answered Oct 14, 2019 in Power BI by Andrew Caulton
19,713 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 23, 2019 in Power BI by VNK
18,425 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,130 points
990 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

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

answered Aug 22, 2018 in Power BI by nirvana
• 3,130 points
2,447 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
• 18,570 points
1,127 views
+1 vote
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
• 52,360 points
1,417 views
+2 votes
3 answers

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, 2019 in Power BI by Cherukuri
• 33,030 points
152,469 views
+1 vote
1 answer

Power BI: TopN and All Other

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

answered Mar 18, 2019 in Power BI by Cherukuri
• 33,030 points
5,569 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP