Forum Discussion
Extract Date from Text
Dear team
I had data , which is collecting of date value .
IF Date already filled with right format then keep it ( row no 1 )
beside exact date value , we are inserting "est" before date if those date was an expectation of date . (row no 2 and 3)
pls check table below
is this possible ??
tell me how to do it
Thanks
Syaiful
Hi Anonymous ,
Try this
Column = IF(MID('Table'[Column1],1,3)="est",IF(LEN(MID('Table'[Column1],5,99))<=5,MID('Table'[Column1],5,99)&"/19",MID('Table'[Column1],5,99)),'Table'[Column1])Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
Use left,right and mid function and put the values into date function or but in dd-MMM-YY format as date
Try
new date = mid(table[date],5,2) & "-" & mid(table[date],8,3)& "-" & right(table[date],2)Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
Hi Anonymous ,
You can use MID() function to extract value from text and & symbol to splicing value and IF() function to define the year if the MID() value is empty.
Column = MID('Table'[date],5,2)&"-"&MID('Table'[date],8,3)&"-"&IF(MID('Table'[date],12,2)="","19",MID('Table'[date],12,2))Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Try this
Column = IF(MID('Table'[Column1],1,3)="est",IF(LEN(MID('Table'[Column1],5,99))<=5,MID('Table'[Column1],5,99)&"/19",MID('Table'[Column1],5,99)),'Table'[Column1])Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
