cancel
Showing results for
Did you mean:
Frequent Visitor

Contagem de senhas por hora

- São emitidas quase 350 senhas por dia no atendimento, em diferentes horas no dia.

Preciso saber como somar as senhas emitidas por hora e colocar isso no relatorio de forma que posso extrair a quantidade emitida por hora e por dia.

Quero um relatorio onde possa extrair essa quantidade em coluna por dia conforme a coluna F.

2 ACCEPTED SOLUTIONS
Community Support

Here are the steps you can follow：

1. Create calculated table.

``````Table 2 =
var _table1=
SUMMARIZE(
'Table','Table'[Hora],
"Hora Inicio",
IF(
LEN('Table'[Hora])=10,
TIME(VALUE(LEFT('Table'[Hora],1)),0,0),
TIME(VALUE(LEFT('Table'[Hora],2)),0,0)),
"Hora Fim",
IF(
LEN('Table'[Hora])=10,
TIME(VALUE(LEFT('Table'[Hora],1)),59,59),
TIME(VALUE(LEFT('Table'[Hora],2)),59,59)))
return
SUMMARIZE(
_table1,[Hora Inicio],[Hora Fim],"Quantidate",
COUNTX(
FILTER(ALL('Table'),
'Table'[Hora]>=[Hora Inicio]&&'Table'[Hora]<=[Hora Fim]),[Data]))``````

2. Result:

Best Regards,

Liu Yang

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

Frequent Visitor

Deu certo, e funcionando.

4 REPLIES 4
Community Support

Here are the steps you can follow：

1. Create calculated table.

``````Table 2 =
var _table1=
SUMMARIZE(
'Table','Table'[Hora],
"Hora Inicio",
IF(
LEN('Table'[Hora])=10,
TIME(VALUE(LEFT('Table'[Hora],1)),0,0),
TIME(VALUE(LEFT('Table'[Hora],2)),0,0)),
"Hora Fim",
IF(
LEN('Table'[Hora])=10,
TIME(VALUE(LEFT('Table'[Hora],1)),59,59),
TIME(VALUE(LEFT('Table'[Hora],2)),59,59)))
return
SUMMARIZE(
_table1,[Hora Inicio],[Hora Fim],"Quantidate",
COUNTX(
FILTER(ALL('Table'),
'Table'[Hora]>=[Hora Inicio]&&'Table'[Hora]<=[Hora Fim]),[Data]))``````

2. Result:

Best Regards,

Liu Yang

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

Frequent Visitor

Deu certo, e funcionando.

Frequent Visitor

Esse aqui sao os dados do powre BI

Frequent Visitor

Soma o total emitido nessas horas e forma a coluna
O eixo horizontal deve ficar dias
o eixo vertical em horas

Announcements

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors