Hi,
I want to count the number of months between two dates in power query
I've usedthis works but I have to knnw the number of years between the dates so not great .
Please Login or Register to view this content.
does anyone know a better way, is there some power query date function that does, it, there seems to be a duration.days , but not months.
Any suggestions?
Richard
Last edited by Dicken; 09-28-2022 at 09:03 AM. Reason: Forgot code hash
Capture.JPGPlease Login or Register to view this content.
Last edited by Kerryx; 09-30-2022 at 09:29 AM. Reason: more info
Thank you, works great. The .25? is that a leap year thing, or something else, I'll have to experiment.
Richard
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks