Subtracting 2 dates D

[Akesh]

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])

[v-jingzhang]

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.

[amitchandak]

@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]

Tried both options doesn't work

[mh2587]

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

[Akesh]

Tried this, Doesnt work