Forum Discussion
LucasMascarellD
3 years agoFrequent Visitor
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...
- 3 years ago
I think I initially misunderstood your requirement. Please try
=
NETWORKDAYS (
MAX ( MIN ( Calendario[Date] ), TODAY () ),
MAX ( Calendario[Date] ),
1,
Feriados
)
LucasMascarellD
3 years agoFrequent Visitor
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.