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)
mattww's avatar
mattww
Icon for Responsive Resident rankResponsive Resident
4 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

  • 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.