How to convert a date field from 2w,2d,-1d to proper date format

[rajendraongole1]

Hi All,

I have a table with field Current date and due date in the below format. I want to convert the data in the field due date to proper format.

As listed we have data like 2w (week), 2d, (days),3d (3 days) like that . we have to get the due date output should be from current date to due date 2d means next after 2 days date format. 

mm/dd/yyyy format

Any suggestion. Please let us know.

Like example 

Current Date	Due Date	Expected Date
11/10/2022	11/14/2022	11/14/2022
	null	null
11/10/2022	12/14/2022	12/14/2022
	null	null
	null	null
11/10/2022	2w 3d	12/12/2022
11/10/2022	2d	11/12/2022
11/10/2022	2w 2d	12/12/2022

[mangaus1111 · Accepted solution]

Hi @rajendraongole1 ,

see my pbi file. 

https://1drv.ms/u/s!Aj45jbu0mDVJi2da_Op1RvvBu_Ky?e=lAUscz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[daXtreme]

Well, you have to parse the entry and extract the numbers. Then multiply them by the correct number of days (w = 7 days, d = 1) and then add to the start date. This should be done in Power Query.

[rajendraongole1]

Thanks for the update, I have tried with the parse the values in query editor. 

multiply with week for 7 and day with 1.

but not working out in my case. 

Any suggestions on this?