- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Proud to be a Super User! | |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Proud to be a Super User! | |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Replace $ first, then convert to currency type(fixed decimal number)

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
12-02-2024 03:00 AM | |||
11-11-2024 12:05 PM | |||
12-26-2024 10:57 PM | |||
02-19-2025 12:03 PM | |||
12-03-2024 05:51 PM |