Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

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?

1 ACCEPTED SOLUTION

Syndicated - Outbound

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

 

Also you can use summarize or selectcolumns to reduce columns

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

Syndicated - Outbound

@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/

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
avatar user
Anonymous
Not applicable

Syndicated - Outbound

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

Serdet_0-1631607640556.png

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

 

 

Syndicated - Outbound

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

 

Also you can use summarize or selectcolumns to reduce columns

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)