Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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"
Solved! Go to Solution.
Hi @LewisH,
If I understand you correctly, the formula below should work in your scenario.
Workingdays = IF ( ISBLANK ( 'Put Away Headers'[Day_Out] ), BLANK (), CALCULATE ( SUM ( 'DateKey'[IsWorkingDay] ), DATESBETWEEN ( DateKey[Date], 'Put Away Headers'[Registering_Date], 'Put Away Headers'[Day_Out] ) ) )
Regards
Hi,
Does this work?
=CALCULATE(SUM('DateKey'[IsWorkingDay]),FILTER('Put Away Headers','Put Away Headers'[Day_out]<>BLANK()),DATESBETWEEN(DateKey[Date],'Put Away Headers'[Registering_Date],'Put Away Headers'[Day_Out]))
Hi,
Does this work?
=CALCULATE(SUM('DateKey'[IsWorkingDay]),FILTER('Put Away Headers','Put Away Headers'[Day_out]<>BLANK()),DATESBETWEEN(DateKey[Date],'Put Away Headers'[Registering_Date],'Put Away Headers'[Day_Out]))
Hi @LewisH,
If I understand you correctly, the formula below should work in your scenario.
Workingdays = IF ( ISBLANK ( 'Put Away Headers'[Day_Out] ), BLANK (), CALCULATE ( SUM ( 'DateKey'[IsWorkingDay] ), DATESBETWEEN ( DateKey[Date], 'Put Away Headers'[Registering_Date], 'Put Away Headers'[Day_Out] ) ) )
Regards
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
75 | |
72 | |
39 | |
29 | |
27 |
User | Count |
---|---|
97 | |
96 | |
58 | |
44 | |
40 |