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
    )

LucasMascarellD's avatar
LucasMascarellD
Frequent Visitor
3 years ago

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's avatar
tamerj1
Community Champion
3 years ago

 Please create a measure 

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

and let me know what it returns. 

LucasMascarellD

  • LucasMascarellD's avatar
    LucasMascarellD
    Frequent Visitor
    3 years ago

    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's avatar
      tamerj1
      Community Champion
      3 years ago

      LucasMascarellD 

      I think I initially misunderstood your requirement. Please try

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

      • LucasMascarellD's avatar
        LucasMascarellD
        Frequent Visitor
        3 years ago

        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?