Forum Discussion

Akesh's avatar
Akesh
New Member
4 years ago

Subtracting 2 dates D

Hi,

I created a column whereby I subtracted 2 date columns. it works but when I display it in a table or matrix, it duplicates the values.

 

#Test = 1.0*('BI rpt_TelkomOrderStatus'[DeliveryStatusDate] - 'BI rpt_TelkomOrderStatus'[SaleDateTo])
 

 

Need Help

5 Replies

  • mh2587's avatar
    mh2587
    Icon for Super User rankSuper User
    4 years ago

    Try this approach 
    DATEDIFF(<Date1>, <Date2>, <Interval>)

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Akesh , Try like

    #Test = int('BI rpt_TelkomOrderStatus'[DeliveryStatusDate] - 'BI rpt_TelkomOrderStatus'[SaleDateTo])

     

    or

     

    #Test = datediff('BI rpt_TelkomOrderStatus'[SaleDateTo], 'BI rpt_TelkomOrderStatus'[DeliveryStatusDate] , day)

    • Akesh's avatar
      Akesh
      New Member
      4 years ago

      Tried both options doesn't work

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Akesh 

     

    A newer PBI Desktop August version (v. 2.108.825.0) was released on 8/17/2022, which has several fixes on issues in the previous version. You could try the latest version and test it again. 

     

    In my test with the latest version, I cannot reproduce the problem. If I only add #Test column to a table or a matrix visual, it doesn't have duplicated values there. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.