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
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
Community Champion
Community ChampionHi 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
Thanks) I got a solution.