Calculate Difference Between Two Date/Time Values in a new column

Hi pswain 

In Power Query create a new Conditional Column and subtract Closed Month from Creation Month.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Creation Month", type datetime}, {"Closed Month", type datetime}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Duration", each [Closed Month]-[Creation Month])
in
    #"Added Custom"

Sample file : Duration

Phil 

If I answered your question please mark my post as the solution.

If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

Hi, pswain ,

You just need to copy this to your new calculated column:

DIFF = 
VAR _D = DATEDIFF('YourTable'[Closed Month],'YourTable'[Creation Month],DAY)
VAR _H = DATEDIFF('YourTable'[Closed Month],'YourTable'[Creation Month],HOUR)-_D*24
VAR _M = DATEDIFF('YourTable'[Closed Month],'YourTable'[Creation Month],MINUTE)-_D*24*60-_H*60
RETURN
_D & " days" & _H & " hours" & _M & " minutes"

 Best.