Forum Discussion
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'[DeliveryStatus...
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)
Tried both options doesn't work
