Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 identificar, onde está o erro. Exemplo: data de input 16/10/2023 e envio federação 17/10/2023, deveria retornar 24, porém o resultado é 48.
Agradeço pela ajuda.
Solved! Go to Solution.
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.
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.
The WEEKDAY(...,2) for these dates is 1 and 2.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
71 | |
37 | |
21 | |
19 | |
15 |
User | Count |
---|---|
125 | |
33 | |
27 | |
24 | |
23 |