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
17 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 by anonymous
• 19,510 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
• 39,170 points
43 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
• 39,170 points
243 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,805 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
6,498 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
68 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
535 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,090 points
99 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
• 39,170 points
91 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
• 19,510 points
2,359 views
+1 vote
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
• 19,510 points
346 views