Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Boa tarde a Amigos do Power BI!
Sou novo aqui, estou aprendendo a utilizar a ferramenta, gostaria de uma ajuda de vocês.
Eu tenho uma planilha de chamados de Help Desk onde estou identificando o backlog anterior de cada Grupo de Suporte.
No Excel está funcionando perfeitamente, porém, não estou conseguindo aplicar a fórmula no DAX.
Tabela:
Semana_A | Semana_F | Atendimento | Ãrea | Resultado_Backlog |
201747 | 201748 | N2 | Financas | 3 |
201725 | 201749 | N2 | Financas | 2 |
201743 | 201749 | N2 | Financas | 2 |
201726 | 201727 | N2 | Financas | 2 |
Na coluna Resultado_Backlog estou utilizando a seguinte fórmula no Excel:
=CONT.SES($A:$A;"<" & $B2;$B:$B;">=" & $B2;$C:$C;"=" & $C2;$D:$D;"=" & $D2)
Resumo:
Semana_A - É "Ano e Semana" que o chamado foi aberto;
Semana_F - É "Ano e Semana" que o chamado foi fechado;
Ficarei muito agradecido pela ajuda!!
Solved! Go to Solution.
Hi @Anonymous,
Please create a calculated column with below DAX code:
Result = COUNTROWS ( FILTER ( CountIf, CountIf[Week_A] < EARLIER ( CountIf[Week_F] ) && CountIf[Week_F] >= EARLIER ( CountIf[Week_F] ) && CountIf[Attend] = EARLIER ( CountIf[Attend] ) && CountIf[Area] = EARLIER ( CountIf[Area] ) ) )
By the way, to get your answer more quickly, it would be better to post questions in English.
Best regards,
Yuliana Gu
Many thanks Yuliana! I am very happy with your help, it worked perfectly.
Regards,
Ivan Sousa
Hi @Anonymous,
Please create a calculated column with below DAX code:
Result = COUNTROWS ( FILTER ( CountIf, CountIf[Week_A] < EARLIER ( CountIf[Week_F] ) && CountIf[Week_F] >= EARLIER ( CountIf[Week_F] ) && CountIf[Attend] = EARLIER ( CountIf[Attend] ) && CountIf[Area] = EARLIER ( CountIf[Area] ) ) )
By the way, to get your answer more quickly, it would be better to post questions in English.
Best regards,
Yuliana Gu
Many thanks Yuliana! I am very happy with your help, it worked perfectly.
Regards,
Ivan Sousa
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |