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

Hi Matt,

 

Thanks for the information. I am doing it in DAX.  If I try to use the DATEADD function in DAX like this:

 

_First Response Calc = DATEADD('RowData'[First Response Target],'RowData'[First Response Deviation in Minutes]/1440,DAY)
 
I will get an error indicating "A date column containing duplicate dates was specified in the call to function 'DATEADD'. This is not supported.
 
Kevin
mattww's avatar
mattww
Icon for Responsive Resident rankResponsive Resident
4 years ago

Is that a measure or calculated column? And same question for [First Response Deviation in Minutes]

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    'RowData'[First Response Target] is a date/time field from the dataset.

    RowData'[First Response Deviation in Minutes] is a whole number of minutes field from the dataset.

    Using DAX, I am trying to add the deviation minutes to the First Response Target date.

     

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

      Try this

       

      _First Response Calc =
      RowData[First Response Target]
      + TIME ( 0, 0, RowData[First Response Deviation in Minutes] )

       

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

       

      Matt

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        I get an error indicating "An argument of function 'TIME' has the wrong data type or the result is too large or too small"