Hierarchy on a duration, and duration if no end date

[Magrfa]

Sorry I am still new to Power BI

I have a column which is a duration. calculated from a Logon date/time colomn and a Logoff date/time column. (Logoff-Logon)

1. Is there a way that if there is no logoff value it will calculate to Now or today or a similar function.

2. I have added this to my visuals but would like this to have a hierachy like a date/time field, is there a way to achive this

some of the users have a duration in Days, some in Hours and some in Minuites so it would be great to be-able to dynamically change between these for the visuals

Below is a copy of the Data, PowerBI would not let me select a range to copy the datd so I had to provide it as an image

[hokeson · Accepted solution]

create a new column where you enter the logoff value and when empty then now()

= Table.AddColumn(#"Renamed Columns", "Custom", each if [LogOff] = null then DateTime.LocalNow() else [LogOff])

to format duration output you can use the following guide

Calculate Duration in Days Hours Minutes and Seconds Dynamically in Power BI using DAX - RADACAD

hope it helps