cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
160475
Helper I
Helper I

working days calculation

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 

160475_0-1666097927515.png

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 

160475_1-1666098038512.png

 

i need to calculate working days in each moth can you help please ?? 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

2 REPLIES 2
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
amitchandak
Super User
Super User

@160475 , Check if networkdays can help

https://amitchandak.medium.com/power-bi-dax-function-networkdays-5c8e4aca38c



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors