Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Datediff between date and minimum date

Hi,   I have two tables. First table contains workorder information. Second table contains material transations information. Join is on workorder ID and operation sequence number. I try to compare ...
Need Help
Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

Hi Anonymous 

Please create the following measure:
difference = Datediff( Min(Transcation date), Max(Release date),day)

 

Let me know whether you are getting desired result of not.

 


If my post helps please give kudos and accept it as a solution!
Thanks

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Uzi2019,

 

Was able to get this working, but facing the problem that the days include non working days. Added new working calender table to datamodel, linked on transaction date and working calender date. Extending the formula to 'CALCULATE(MIN(TRANSACTION DATE), MAX(RELEASE DATE),DAY), working CALENDER DATE = "Y") does not exclude non working days. Formula not ok? Or what do you think is not ok.