Forum Discussion
changing data type
hi, Anonymous
You may try this way:
Select t_time column, duplicate the column, then split the duplicate column
Then filter column t_time - Copy.1 who is greater than 2
Best Regards,
Lin
Are you trying to do this in DAX or Power Query?
Can you post an example of the data? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, check out these links:
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
https://community.powerbi.com/t5/Quick-Measures-Gallery/Milliseconds-Duration/m-p/406698
Hi can u check my latest reply, I have posted a picture which shows what error I get. I checked ur links but cant fix this issue with it because it contains values greater than 24 hours.
hi, Anonymous
Can you post an example of the data? from the screenshot, we couldn't get other details.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Lin
Something like this?
I have selected the time value which is causing the problem.
hi, Anonymous
Power bi not support duration type, I'd like to suggest you convert it as total second or other similar numeric value to calculate.
You can also take a look at below blog to know how to handle with duration in power bi:What is your expected output in power bi(not power query )? maybe we could help you get your expected output by DAX.
Best Regards,
Lin