Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 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
    4 years ago

    This should do it

     

     

    Add column > Custom column

     

    [First Response Target] + #duration(0,0,[First Response Deviation in Minutes],0)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

mattww's avatar
mattww
Icon for Responsive Resident rankResponsive Resident
4 years ago

This should do it

 

 

Add column > Custom column

 

[First Response Target] + #duration(0,0,[First Response Deviation in Minutes],0)
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Matt,

    Added the Custom Column using Power Query worked great. 

    Thanks,

    Kevin

  • mattww's avatar
    mattww
    Icon for Responsive Resident rankResponsive Resident
    4 years ago

    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