Reply
nckchowdary
New Member

Conversion

Hi Team, I'm new to PBI, I need your help in below question,

I have a field called year_income, it contains values like $5000,$1200,$4500,etc.....

here my requirement is I want to create a column called Monthly_income, So my formuls was year_income/12, but I'm getting error because of year_income was in text datatype,

So could you please let me know how to convert year_income column to integer, or how to extract 5000,1200,4500,etc... without '$'

 

 

Thanks in advenaced

2 ACCEPTED SOLUTIONS
ZhangKun
Super User
Super User

Replace $ first, then convert to currency type(fixed decimal number)

ZhangKun_0-1741877971087.pngZhangKun_1-1741878013847.png

 

View solution in original post

jgeddes
Super User
Super User

Here is a link to the Microsoft Learn article on type conversion. 
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-types 





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

Proud to be a Super User!





View solution in original post

6 REPLIES 6
v-ssriganesh
Community Support
Community Support

Hi @nckchowdary,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

v-ssriganesh
Community Support
Community Support

Hi @nckchowdary,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

v-ssriganesh
Community Support
Community Support

Hi @nckchowdary,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @ZhangKun & @jgeddes for sharing valuable insights.

 

Could you please confirm if your query has been resolved by the provided solution? If so, please mark it as the solution. This will help other community members solve similar problems faster.

Thank you.

jgeddes
Super User
Super User

Here is a link to the Microsoft Learn article on type conversion. 
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-types 





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

Proud to be a Super User!





Thank you

ZhangKun
Super User
Super User

Replace $ first, then convert to currency type(fixed decimal number)

ZhangKun_0-1741877971087.pngZhangKun_1-1741878013847.png

 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)