Count Weekdays Between Two Date Excluding Weekends

Question

Dears,Thank you for your usual support. Kindly, I would like to count the weekends between two dates.&nbsp;The scenario is, I have projects creation date and there is some projects have initial baseline (in case the project has been baselined). In case there is a baseline, then I need to count the weekdays (without weekends) between (Initial Baseline &amp; Creation date)Otherwise, the measure should count the weekdays (without weekends) between (Today &amp; Creation date)&nbsp;Note: I have already a calender date and I have identified if the date is a weekend or not (1 if weekends and 0 is weekday)&nbsp;This is a sample dataProject Name: Project XCreation Date: 1/26/2020Initial Baseline Date: Blank&nbsp;

amitchandak · Accepted Answer

Max date can be replaced with todayWorking day = CALCULATE(COUNTx(FILTER(Project,Project[Creation Date]&lt;=max('Date'[Date]) &amp;&amp; 
(ISBLANK(Project[End Date]) || Project[End Date]&gt;max('Date'[Date])) &amp;&amp; date[Weekday]=1),(date[date]))
,CROSSFILTER(Project[Creation Date],'Date'[Date],None))&nbsp;also refer :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.In case it does not help, please provide additional information and mark me with @ Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date RangesConnect on Linkedin

Forum Discussion

Count Weekdays Between Two Date Excluding Weekends

2 Replies

Related content

Weekend and Weekday Analysis

DATEDIFF excluding weekends

Get only weekdays (exclude weekends) in measure

Previous Day Balance - Excluding Weekends

Exclude weekends from Date Measure