Calculate time between two dates

[Sam_Jain]

Hello community,

I have two date/time columns and i need to calculate the difference between them (in minutes) but based on a condition from a third column - only if it is not null  (also a date/time column)

Thanks in advance.

[ray_aramburo · Accepted solution]

Go to Transform Data (Power Query) -> Add Column -> Custom column and type the following logic:

if [Third Column] is null then null else

if [Third Column] = "condition you want to consider" then [First Column] - [Second Column] else null

Then, convert the data type from the column you just created to Duration, and then go to Transform -> Duration -> Minutes