Forum Discussion
Solved
NETWORKDAYS PER MONTH DAX
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 balan...
I think I initially misunderstood your requirement. Please try
=
NETWORKDAYS (
MAX ( MIN ( Calendario[Date] ), TODAY () ),
MAX ( Calendario[Date] ),
1,
Feriados
)
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.
Please create a measure
MIN ( MAX ( Calendario[Date] ), TODAY () )and let me know what it returns.
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
I think I initially misunderstood your requirement. Please try
=
NETWORKDAYS (
MAX ( MIN ( Calendario[Date] ), TODAY () ),
MAX ( Calendario[Date] ),
1,
Feriados
)