- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Row for every day and every employee
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous , You are creating a measure. You need to create a new table.
Also you can use summarize or selectcolumns to reduce columns
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-16-2025 12:45 PM | |||
10-24-2024 09:50 AM | |||
11-15-2024 12:53 AM | |||
10-07-2024 03:08 AM | |||
11-27-2024 10:26 PM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |