How to remove text from a date column DAX

[Jay2077]

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 

[V-pazhen-msft]

@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

[Fowmy · Accepted 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.