Forum Discussion
Time Duration to Date Conversion
Super UserAnonymous , You can split it on power Query using split by delimiters. Then you can remove the text.
Then you add it date
date(2022,01,01) + [week]+7 + [Day] + Time([Hour], [Minute], 0)
Hi Amit,
Thanks for the reply. I did get your suggestion.
As my input is in Duration , how can we convert the same into a date column. Thanks.
Hi amitchandak ,
Can you please advice with another solution, As I need to use this DATE column in a DATEDIFF (Example : Candidate dropout since = DATEDIFF( createdate,date)
where as date is the column which we i am trying to create now from the duration (shown in the above table).
Please help,
Thanks,Naveen
Hi amitchandak :
As I am new to Power BI, I got struck here.
As per your suggestions, I did Split the delimiters and was able to achieve this . Can you please give me little more detailed steps on your second step (date(2022,01,01) + [week]+7 + [Day] + Time([Hour], [Minute], 0) ) where I was not able to frame a logic as per your suggestion.
Also, recently month is also added to the data with (Month Week Day Hour Minute)
Please help to crack this logic.
input:
input Derived Date 1M 2w 5d 18h 54m 1d 1h 3m 2h 20m 10m output Month Week Day hours minutes 1 2 5 18 54 - 1 1 3 - - 2 20 - - - 10