Row for every day and every employee

[Anonymous]

Hi,

I want to create a table which contains one row per employee per day. (My end result is to show total available labour on any given day)

My existing tables are as follows

1. Date table (calendar auto)  

2. Employee Name / Employee ID table

Any ideas on how to achieve this?

[amitchandak]

@Anonymous , Cross Join between date and Employee table

Crossjoin(Date, Employee)

refer if needed

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

[Anonymous]

Thanks for your response. When adding this measure I get the below error?

Please note my employees table also contains other columns such as employee ID, employee reference and so on...

[amitchandak · Accepted solution]

@Anonymous , You are creating a measure. You need to create a new table.

Also you can use summarize or selectcolumns to reduce columns