#Duration function

Matt,

Added the Custom Column using Power Query worked great. 

Thanks,

Kevin

Ok, I see the Time doesn't support the duration beyond 24 hours. I was using DAX because I was trying to replicate a report that was written in Tableau initially. Tableau uses this function for a calculated field to calculate the difference between the Date/Time Opened field and the First Response Target date field + the Deviation Minutes.

(DATEDIFF('minute',[Date/Time Opened],[First Response Target])
+ [First Response Deviation in Minutes]) / 60

PowerBI DateDiff was giving me bad results when trying to do a similar thing:

_First Response (hours) = DATEDIFF('RowData'[Date/Time Opened],'RowData'[First Response Target] + 'RowData'[First Response Deviation in Minutes], MINUTE) /60

Thanks so much for your help. I will trying using the #duration function and creating the column using Power Query.

Kevin

Ah yeah, the date functions in Power BI can be a bit fiddly compared to Tableau.

It would probably be possible in DAX if you really needed to, it would involve calculating the number of days, hours, minutes and seconds. It's probably not worth the hassle

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Matt

Thanks again Matt for your help. Once I figure it out using Power Query I will post the solution here.

Hey Anonymous 

Glad it worked, could you check you marked my reply (or Anonymous) as the solution, you've marked your own as a solution instead so it's displaying the wrong message in the thread

Good luck with the rest of your report

Matt