Forum Discussion

luciano1903's avatar
luciano1903
Frequent Visitor
2 years ago
Solved

MEDIDA DAX RETORNANDO COM VALORES DIVERGENTES

boa tarde   Pessoal criei uma coluna no PBI, nela ela calcula o tempo entre datas desconsiderando sábado e domingo, porém em algumas linhas ele retorna com o valor de 48 horas, não consegui identif...
DAX
  • lbendlin's avatar
    lbendlin
    2 years ago

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

  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.