Problem with working days formula

[Anonymous]

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

[Anonymous]

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

[PC2790 · Accepted solution]

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.