Conversion

[nckchowdary]

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

[ZhangKun · Accepted solution]

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

[v-ssriganesh]

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]

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]

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 · Accepted solution]

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 

[nckchowdary]

Thank you

[ZhangKun · Accepted solution]

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