cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

## Networkdays DAX function

Hello,

can somebody help me? Is there any simple method how to calculate Working Days left in actual month?

In excel I am using NETWORKDAYS function.

Any example?

Thanks

1 ACCEPTED SOLUTION
Super User

Try something like this:

```WD = VAR WDinMonth = CALCULATE(COUNTROWS('Calendar');
FILTER('Calendar'; 'Calendar'[DayOfWeekNumber] >= 1
&& 'Calendar'[DayOfWeekNumber] <= 5 ))

VAR WDinMonthThusFar = CALCULATE(COUNTROWS('Calendar');
FILTER('Calendar'; 'Calendar'[DayOfWeekNumber] >= 1
&& 'Calendar'[DayOfWeekNumber] <= 5 ) && 'Calendar'[Date] < TODAY())

RETURN (WDinMonth -WDinMonthThusFar)```

I'm assuming you have some sort of [Date] column in your table.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
7 REPLIES 7
Community Champion

@mstefancik Check out this blog post. It may be what you want.

This is what I found, and tried to replicate. At this time I have got this:

WD = CALCULATE(COUNTROWS('Calendar');
FILTER('Calendar'; 'Calendar'[DayOfWeekNumber] >= 1
&& 'Calendar'[DayOfWeekNumber] <= 5 ))

Which works fine. It returns count of working days in month.

But how to filter it, to get the count of working days till the end of the month?

So to show me for today: 5 working days, tommorow 4 working days, etc

Super User

Try something like this:

```WD = VAR WDinMonth = CALCULATE(COUNTROWS('Calendar');
FILTER('Calendar'; 'Calendar'[DayOfWeekNumber] >= 1
&& 'Calendar'[DayOfWeekNumber] <= 5 ))

VAR WDinMonthThusFar = CALCULATE(COUNTROWS('Calendar');
FILTER('Calendar'; 'Calendar'[DayOfWeekNumber] >= 1
&& 'Calendar'[DayOfWeekNumber] <= 5 ) && 'Calendar'[Date] < TODAY())

RETURN (WDinMonth -WDinMonthThusFar)```

I'm assuming you have some sort of [Date] column in your table.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Hello,

If I have dates in the below format and  there is a condition that I can not use calendar table,

How would I calculate networking days in a period,

I have period, start date and end date and i want to calculate networking days between these 2 dates in power bi, how can I do that...

Hi @Greg_Deckler exactly, I have got Date column in my Kalendar table.

So I should be able just copy your code. That is what I did, but got the error:

Do I need to adjust something?

Already found it and now it works like a charm. Many thanks @Greg_Deckler.

FYI error was in the second filter, mismatch of parenthesis.

WD = VAR WDinMonth = CALCULATE(COUNTROWS('Kalendar');
FILTER('Kalendar'; 'Kalendar'[DayOfWeekNumber] >= 1
&& 'Kalendar'[DayOfWeekNumber] <= 5 ))

VAR WDinMonthThusFar = CALCULATE(COUNTROWS('Kalendar');
FILTER('Kalendar'; 'Kalendar'[DayOfWeekNumber] >= 1
&& 'Kalendar'[DayOfWeekNumber] <= 5 && 'Kalendar'[Date] < TODAY()))

RETURN (WDinMonth -WDinMonthThusFar)

Anonymous
Not applicable

Can we get this to exclude holidays?

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors