Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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 achieve this :
Show me backups that are under -10 hours.
For example the marked below.
How is that possible?...
I just want the ones that are over 10 hours of duration to be shown. not the other ones.
Solved! Go to Solution.
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.
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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.