Forum Discussion

Jay2077's avatar
Jay2077
Helper III
5 years ago
Solved

How to remove text from a date column DAX

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 

Need Help
Tips and Tricks
  • Fowmy's avatar
    Fowmy
    5 years ago

    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. 

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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