I have two dates in a table, Registering Day and Day out.
There will always be a registering date, but not always a day out. I need to work out the average daby between but this is casuing errors beciase one of the days will be blank. I have started with something like this but can anyone guide me on how to correct it. Thanks
Workingdays = CALCULATE(SUM('DateKey'[IsWorkingDay]), DATESBETWEEN(DateKey[Date],'Put Away Headers'[Registering_Date],'Put Away Headers'[Day_Out])) -- Here i need to filter out blank "Day Out"