MEDIDA DAX RETORNANDO COM VALORES DIVERGENTES

The WEEKDAY(...,2) for these dates is 1 and 2.

Hi luciano1903 ,

For Ibendlin's answer I think it's correct, in your DAX code, WEEKDAY([Date],2)<6,24 is counting by days, that is why it returns 48 only in 16/10/2023-17/10/2023.

If you want to change all the results to 24 that's fine too.

Column = 
VAR _A = SUMX(FILTER(CALENDAR('Table'[Data Input],'Table'[Data Output]),WEEKDAY([Date],2)<6),24)
VAR _AA = IF(_A = 48,24,_A)
RETURN _AA

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.