Forum Discussion
Solved
Dynamical summarizecolumns or subquery
Hi. I have table like this: DateTime, Cabinet_id, Employee_id 01.01.20 11:00 10 25 01.01.20 11:00 10 12 01.01.20 11:05 10 25 01.01.20 1...
Hi Alexandergikalo ,
Create the calculated column:
HOUR('Table (2)'[DateTime])And this measure:
Measure 2 =COUNTX(SUMMARIZE('Table (2)'; 'Table (2)'[DateTime]; 'Table (2)'[Cabinet_id]; 'Table (2)'[Hour]); 'Table (2)'[Hour])Ricardo
camargos88
Community Champion
Community ChampionHi Alexandergikalo ,
Try creating a calculated column:
Hour = HOUR('Table'[DateTime])
After that:
Ricardo
Not that case(
Sql query will return this tesult
01.01.20 11:00 6 recors
Your count - 8
I neet to exlude some kind of doubles.
- camargos88
Hi Alexandergikalo ,
Create the calculated column:
HOUR('Table (2)'[DateTime])And this measure:
Measure 2 =COUNTX(SUMMARIZE('Table (2)'; 'Table (2)'[DateTime]; 'Table (2)'[Cabinet_id]; 'Table (2)'[Hour]); 'Table (2)'[Hour])RicardoThanks) I got a solution.