Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
dears,
good day!!
i have a file called dim date it has a culomns called G_date where it shows the date from 12/29/2008 till 5/13/2029
how can i calculate the working days if holidays are fri and sat
i have another culomn called vacation where 1 vacation and blank working days
i need to calculate working days in each moth can you help please ??
Solved! Go to Solution.
@160475 , Check if networkdays can help
https://amitchandak.medium.com/power-bi-dax-function-networkdays-5c8e4aca38c
Hi @160475,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
@160475 , Check if networkdays can help
https://amitchandak.medium.com/power-bi-dax-function-networkdays-5c8e4aca38c
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
64 | |
60 | |
51 | |
36 | |
36 |
User | Count |
---|---|
81 | |
72 | |
58 | |
45 | |
44 |