Forum Discussion
Calculate time between two dates
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.
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
1 Reply
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