Forum Discussion
ArchStanton
Power Participant
Power ParticipantCalculate the Working Days between two dates
Hi, I have a Date Table that tells me if the day is a Working Day or not: Is Working Day = IF('Date'[Weekday]>5,0,IF('Date'[Public Holiday]>1,0,1)) The answers is simply: True / False ...
Hi ArchStanton ,
You could create a measure like
Measure = COUNTROWS(FILTER('Date',[Date]>=MAX('Deferrals'[actualstart])&&[Date]<=MAX('Deferrals'[actualend])&&[Is Working Day]=1))
Measure and calculated column are different. You could refer to
Power BI: Calculated Measures vs. Calculated Columns | by Rod Castor | Towards Data Science
Calculated Column and Measure in Power BI (powerbiconsulting.com)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ArchStantonPower Participant
Power Participant
Hi Stephan,
I tried your code but got this message:
I do have something that works already but it's computing an extra day for some tickets which could be something to do with TimeStamped values? It doesn't affect every ticket no so this can be tolerated. I would have liked to test your version as well if possible?
Thanks