Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table called master and a column called expiry date which contains dates but also text like 'rolling' I want to create a new column which excludes this text and only includes the date values.
Any help greatly appreciated
Solved! Go to Solution.
@Jay2077
You can replace "rolling" with null in Power Query and set Data Type as Date. It is the best way to do it.
Using DAX, you can use RIGHT, MID or LEFT to achieve this , you need to share sample data to understand the format of the data.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Jay2077
Can you share a screenshot? In he date column with text, are the texts always at the same position?
For example:
rolling2021.1.1
rolling2021.1.2
Paul Zheng _ Community Support Team
@Jay2077
You can replace "rolling" with null in Power Query and set Data Type as Date. It is the best way to do it.
Using DAX, you can use RIGHT, MID or LEFT to achieve this , you need to share sample data to understand the format of the data.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.