Forum Discussion

bparikh's avatar
bparikh
Regular Visitor
5 years ago
Solved

Date difference in Months - Power Query

Hello Experts,   I've two DateTime columns and am trying to find the difference in Months by adding a new column but getting an error. I'm using = Date.Month ([Date1] - [Date2]) Date1 & Date2 bot...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    bparikh 

    if you need the number of months between the dates then add the following, it should work for Date/Time

     = Number.Round(Number.From(([Date 2] - [Date 1])/( 365.25 / 12 )) ,0 )

     

LeTapia's avatar
LeTapia
New Member
3 years ago

What about this function

(Date1 as date , Date2 as date)=>
let
    Source =
            List.Generate(
                () => [y=Date.From(Date1)],
                each [y] <= Date.From(Date2),
                each [y = Date.AddMonths([y] ,1)],
                each [y]
            ),
    Months=List.Count(Source)
in
    Months