Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have 2 tables
the key record in both table is employee ID
I want to create a visual table having Available hours ans Work order actual hours per employee and month, like below
Month | Employee ID | Work order actual hours | Available Hours |
October | 123456 | 100 | 20 |
November | 321654 | 50 | 10 |
Hi @Moha_shanti ,
Thanks for the information you have given.
Please try the add Collum operation on 1st Table using the following DAX after checking the table name and column name:
Work order actual hours = SUMX(FILTER(all('Table_2'),'Table_2'[employee ID]=EARLIER(Table_1[employee ID])),'Table_2'[Work order actual hours])
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Joseph Ji
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
To create a visual table in Power BI that shows both available hours and work order actual hours per employee and month, you'll need to perform a series of steps that involve merging the two tables and then creating a table visualization. Here's a step-by-step guide:
Import Data:
Relationships:
Merge Queries:
Expand the Merged Table:
Create a Table Visualization:
Format the Table (Optional):
Filter (Optional):
Refresh Data:
By following these steps, you should be able to create a visual table in Power BI that displays both available hours and work order actual hours per employee and month based on the two tables you have.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
42 | |
21 | |
20 | |
13 |
User | Count |
---|---|
125 | |
41 | |
38 | |
26 | |
24 |