Forum Discussion

aso1's avatar
aso1
Icon for Helper II rankHelper II
6 years ago
Solved

Show data which has duration above X hours

I have a start and end column with date/time stamp. I made a custom column named 'BackupTime' which subtracts the duration from those two : "Duration.ToText([Start]-[End])" ....    I want to achiev...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi aso1 

    Create a column with dax

    hour = DATEDIFF([end],[start],HOUR)

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi aso1 

Create a column with dax

hour = DATEDIFF([end],[start],HOUR)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.