working days calculation

[160475]

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 ?? 

[v-shex-msft]

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

[amitchandak · Accepted solution]

@160475 , Check if networkdays can help

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