topic Re: NETWORKDAYS PER MONTH DAX in DAX Commands and Tips

NETWORKDAYS PER MONTH DAX

LucasMascarellD — Sat, 14 Jan 2023 16:23:09 GMT

HI,

I need to calculate the balance of working days for the current month and the number of working days for the following months,
I did this measure:

It did´t work to calculante the balance of workings days for de current month, the result:

In february it´s ok, but in january it´s need to return 12, today ( 01/14).

Someone can help me?

Re: NETWORKDAYS PER MONTH DAX

tamerj1 — Sat, 14 Jan 2023 18:17:20 GMT

Hi LucasMascarellD
Please use

= NETWORKDAYS ( MIN ( Calendario[Date] ), MIN ( MAX ( Calendario[Date] ), TODAY () ), 1, Feriados )

Re: NETWORKDAYS PER MONTH DAX

LucasMascarellD — Sun, 15 Jan 2023 11:52:47 GMT

Didnt work
The result:

With your measure is on the second line (teste3)

On first line (DiasUteis) I have the working days of the month, It is right.
But in January, needs to return 12, because we still have 12 days to the end of the month.

Re: NETWORKDAYS PER MONTH DAX

tamerj1 — Sun, 15 Jan 2023 13:13:54 GMT

Please create a measure

    MIN (
        MAX ( Calendario[Date] ),
        TODAY ()
    )

and let me know what it returns.

LucasMascarellD

Re: NETWORKDAYS PER MONTH DAX

LucasMascarellD — Sun, 15 Jan 2023 14:44:02 GMT

it´s return

If I use this measure

it´s return to me 12, but in other month returns 12 too and add a new column

Re: NETWORKDAYS PER MONTH DAX

tamerj1 — Sun, 15 Jan 2023 14:51:03 GMT

LucasMascarellD

I think I initially misunderstood your requirement. Please try

=
NETWORKDAYS (
MAX ( MIN ( Calendario[Date] ), TODAY () ),
MAX ( Calendario[Date] ),
1,
Feriados
)

Re: NETWORKDAYS PER MONTH DAX

LucasMascarellD — Sun, 15 Jan 2023 15:02:04 GMT

My english is not the best, Maybe I didnt expresss my self inthe best way.

But the your measure works perfectly

It´s creating a new column with no title, Do you know why?