Log In
Register
Home
Active Member
March 1, 2019
Offline
Hi,
I've been reading with interest the comments at https://www.myonlinetraininghu.....on-datedif concerning Datedif.
I have used this within Excel in particular to find the difference between start date and end date in terms of completed years, months and days.
I had posted a question on how to do this in PowerQuery rather than DAX for use in Excel or Power BI at
https://blogs.msdn.microsoft.c.....-or-excel/
however did not receive a reply.
Since then I have managed to (clumsily) achieve this using the UI only. I'm not a programmer nor coder. Definitely can use XL formulae! I did it in PQ as if I was doing it on a bit of paper with a pen!
There surely would be a simpler / more elegant solution? Happy to discuss the methodology / theory of achieving this rather than being provided with an alternate code.
Cheers
SP
(Mynda - I tried submitting this before but it failed. Please delete the other one!)
July 16, 2010
Offline
Hi Sylvain,
Thanks for sharing your solution. I had a quick look at your file but there are a lot of steps so I didn't spend time trying to follow it all!
I can't imagine there's a much easier way because we simply don't have the logic in Power Query M for a DATEDIFF equivalent.
Mynda
Active Member
March 1, 2019
Offline
Hi Mynda ,
Thanks for looking at my steps. Am sure it could be simplified / consolidated. Regardless it does work which doesn't seen to be an intrinsic issue in relation to timing of execution.
Cheers
SP
1 Guest(s)
