Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Problem with working days formula

Guys, I'm having trouble calculating the working days of today for a date.
I've already revised the formula, the data and always the result is -1

 

Dias úteis = CALCULATE(SUM(Tab_1dado4[Dia Util?]),
DATESBETWEEN(Tab_1dado4[DATA],
Tab_1dado4[FINAL],
Tab_1dado4[Coluna]))-1

 

 

Need Help
  • PC2790's avatar
    PC2790
    4 years ago

    Hey Anonymous ,

     

    You need to have a Dates/Calednar table with continuous dates and join your table with the date table and then modify your code as:

    Calculate(Sum(Tab_1dado4[Dia Util?), Datesbetween(DateTable,

    ab_1dado4[DATA],
    Tab_1dado4[FINAL]))
    See if that works.

2 Replies

  • PC2790's avatar
    PC2790
    Community Champion
    4 years ago

    Hey Anonymous ,

     

    You need to have a Dates/Calednar table with continuous dates and join your table with the date table and then modify your code as:

    Calculate(Sum(Tab_1dado4[Dia Util?), Datesbetween(DateTable,

    ab_1dado4[DATA],
    Tab_1dado4[FINAL]))
    See if that works.
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    PC2790 Thank you very much! It worked out! That was it