Total Availability

[Anonymous]

Hi,

I have a three tables.

table 1 

Date table

table 2

employee ID

table 3

crossjoin table 1 & 2 (creates single row for each employee per day)

I want to create a measure that can be used in a calendar visual which shows a count of all employees. each day (labour availability)

Any ideas?

[Icey]

Hi @Anonymous ,

Any details?

Best Regards,

Icey

[MFelix]

Hi @Anonymous ,

How do you know if the employee is available in that specific day? you refere that you do a cross join so I assume there is also some dates columns on the users table?

Can you please share some sample data.