#Duration function

[Anonymous]

Hi,

I am trying to add a column field with the number of minutes to a Date/Time field in PowerBI Destop. According to my research I can use the #duration function the field to a duration and then add to the Date/Time field, however I cannot find the #duration option in PowerBI.

Everytime I try to use #duration in PowerBI desktop, it references the DURATION function which is used for monetary calculations.

Example: 

_First Response Calc = 'RowData'[First Response Target] + #duration('RowData'[First Response Deviation in Minutes])

Each time i try to use this #duration gets changed to DURATION and it tells me I am missing some of the parameters?

What happened to the #duration function?

Thanks,

Kevin

[mattww]

Hey @Anonymous 

Glad it worked, could you check you marked my reply (or @ThisIsFalse) 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