Forum Discussion

Alexandergikalo's avatar
Alexandergikalo
Frequent Visitor
6 years ago
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...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Alexandergikalo 

Take out Hour part in a new column

Hour = Hour([DateTime])

Or

Hour = Format([DateTime],"HH")

The plot any visual take cabinate_id on row/group and take the sum of hours and use it

measure =count(Table[Hours])

Or

 

measure =Countx(Summarize(Table,Table[Cabinet_id],Table[DateTime],Table[Hour]),[Hour])