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.
Dear All ,
Requiremnet:i Have column as Submitted date i need to find Work day time for that Particular Month ,Suppose 16th Dec then it has to WD+9 as we have to exclude Sat,sun and Holidays,Please find the below Screenshots:
Thanks In Advance.
Solved! Go to Solution.
Hi @ younis,
According to your description, you have evaluated each date is a working day or a non-working day. Now you can use the below calculated column to calculate how many working days there are between the Submitted Date and the Workdays date:
Calworkdays = CALCULATE( COUNTROWS('Calendar table'),
FILTER('Calendar table', 'Calendar table'[Workday/Not A workday]="Working Day"),
DATESBETWEEN('Calendar table'[Date],'Workday table'[Workdays],'Workday table'[Submitted Date])
)
Best Regards
Rena
If It is 25th Dec then WD-5/WD+17 as i have to exclude weekends and 25th Dec is Holiday
Refer
https://community.powerbi.com/t5/Desktop/Number-of-working-days/td-p/22842
https://www.reddit.com/r/PowerBI/comments/93vxcl/how_to_make_power_bi_only_count_working_days/
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 Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Hi @amitchandak ,
In my Case i have already created a table and column which has only working Days,
now supposed submitted date is 6th Jan 2019 now i have to count Workday column till it matches with Submitted date..
Eg:
Submitted Date Workdays
2019/01/06 2019/01/02
2019/01/03
2019/01/06
now Ans should be like WD+3
Conclusion Count till You MATCH
Thanks In Advance.
Hi @ younis,
According to your description, you have evaluated each date is a working day or a non-working day. Now you can use the below calculated column to calculate how many working days there are between the Submitted Date and the Workdays date:
Calworkdays = CALCULATE( COUNTROWS('Calendar table'),
FILTER('Calendar table', 'Calendar table'[Workday/Not A workday]="Working Day"),
DATESBETWEEN('Calendar table'[Date],'Workday table'[Workdays],'Workday table'[Submitted Date])
)
Best Regards
Rena
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |