cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors