Forum Discussion
System control
I have two tables.
A table that records the users who accessed the system.
Another user registration table.
User registration table changes during the month with user entry and exit.
I need to kn...
Hi @tamerj1 pbix
I'm posting my pbix.
I have two tables.
A table that records accesses in the system.
And another table that has the active users in that month.
I created a third Calendar table, linked it to the table that registers the users and the table that contains the active users.
I need to know which active users of that month that did not access the system.
Active users table, it changes every month with outgoing and incoming users. It has a date column always with the last day of the month, example: 01/31/2022.
I created this filter to know which users did not connect to the system.
UserSem = var cc1 = DISTINCTCOUNT(LicenseTotvs[IdUser]) return if (cc1>0, blank(), "No access")
But it is filtering only the table that registers the accesses in the system.
It is not making the comparison between the table of active users and the table that registers the accesses.