Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to 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.
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.
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.
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?
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |