Forum Discussion
Solved
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/...
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
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