Forum Discussion

LucasMascarellD's avatar
LucasMascarellD
Frequent Visitor
3 years ago
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...
"DAX"
@measure
@Power BI
  • tamerj1's avatar
    tamerj1
    3 years ago

    LucasMascarellD 

    I think I initially misunderstood your requirement. Please try

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

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi LucasMascarellD 
Please use

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