Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dears,
Thank you for your usual support. Kindly, I would like to count the weekends between two dates.
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 & Creation date)
Otherwise, the measure should count the weekdays (without weekends) between (Today & Creation date)
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)
This is a sample data
Project Name: Project X
Creation Date: 1/26/2020
Initial Baseline Date: Blank
Solved! Go to Solution.
Max date can be replaced with today
Working day = CALCULATE(COUNTx(FILTER(Project,Project[Creation Date]<=max('Date'[Date]) &&
(ISBLANK(Project[End Date]) || Project[End Date]>max('Date'[Date])) && date[Weekday]=1),(date[date]))
,CROSSFILTER(Project[Creation Date],'Date'[Date],None))
also refer :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Appreciate 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 Ranges
Connect on Linkedin
Hi @tabuzahra ,
You could use COUNTROWS() function. Then you could put date range and conditional column = 0 into your filter.
Max date can be replaced with today
Working day = CALCULATE(COUNTx(FILTER(Project,Project[Creation Date]<=max('Date'[Date]) &&
(ISBLANK(Project[End Date]) || Project[End Date]>max('Date'[Date])) && date[Weekday]=1),(date[date]))
,CROSSFILTER(Project[Creation Date],'Date'[Date],None))
also refer :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Appreciate 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 Ranges
Connect on Linkedin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |