Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

#Duration function

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 ad...
Need Help
  • mattww's avatar
    mattww
    5 years ago

    This should do it

     

     

    Add column > Custom column

     

    [First Response Target] + #duration(0,0,[First Response Deviation in Minutes],0)
mattww's avatar
mattww
Icon for Responsive Resident rankResponsive Resident
5 years ago

Hi Anonymous , are you doing this in DAX or in the Power Query editor. The #duration function is in Power Query so it would be accessible when adding a custom column in your dataset

 

 

If you want to do it in DAX, use DATEADD - DATEADD function (DAX) - DAX | Microsoft Docs

 

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

 

Matt