Forum Discussion
Counting Entries/Exits with Lookup Categories
Hi,
I have a set of data recording security pass access, exits for a building. Each activity (exit or entry) is recorded as an "event" - see below relationship - this is a simplied summary - there are over 5 million line items.
I am trying to create a group count in the main data table using the Card Access Type of "Access Granted" or "Exit Granted".
Any advice is greatly appreciated.
Thanks
Anonymous , You can create a new table
like
new table =
addcolumns(distinct(Table[event type]), "Car access type", Switch(true() , search("Denied",[event type],,0) >0 , "Other" ,
search("Access",[event type],,0) >0 , "Access Granted" ,
"Exit Granted"))
1 Reply
Anonymous , You can create a new table
like
new table =
addcolumns(distinct(Table[event type]), "Car access type", Switch(true() , search("Denied",[event type],,0) >0 , "Other" ,
search("Access",[event type],,0) >0 , "Access Granted" ,
"Exit Granted"))