NETWORKDAYS PER MONTH DAX

[LucasMascarellD]

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?

[LucasMascarellD]

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.

[tamerj1]

 Please create a measure 

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

and let me know what it returns. 

@LucasMascarellD

[LucasMascarellD]

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

[tamerj1 · Accepted solution]

@LucasMascarellD 

I think I initially misunderstood your requirement. Please try

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

[LucasMascarellD]

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?

[tamerj1]

Hi @LucasMascarellD 
Please use

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