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

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

pswain — Mon, 19 Oct 2020 16:16:54 GMT

Hi All,

I have 2 column below, I would like to have the diffrence in days hours minutes like 2 days 12 hours 6 minutes... I am new to powerbi, can someone help me to provide me step by step process, I would really appreciate it. Thanks have a good day.

Regards,

Prasanjit

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

manikumar34 — Tue, 20 Oct 2020 11:59:38 GMT

pswain ,

Use DATEDIFF function to get the required output.

Regards,

Manikumar

Appreciate your Kudos. Accept as solution if this is helpful

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

PhilipTreacy — Tue, 20 Oct 2020 12:12:21 GMT

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.

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

DavisBI — Wed, 21 Oct 2020 03:40:59 GMT

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.