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
36 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
• 32,440 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
• 51,160 points
71 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
• 51,160 points
435 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
2,915 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, 2019 in Power BI by VNK
10,596 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
127 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 21, 2018 in Power BI by nirvana
• 3,060 points
869 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
• 17,890 points
177 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
• 51,160 points
168 views
+3 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, 2019 in Power BI by Cherukuri
• 32,440 points
11,588 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
• 32,440 points
1,244 views