Forum Discussion

Moha_shanti's avatar
Moha_shanti
Regular Visitor
2 years ago

Employee Available report

I have 2 tables 1st table has 3 columns are the employee ID, Month and available hours. 2nd table has alos employee ID, Month, work orders acutal hours and more data. the key record in both tabl...
v-jincheng-msft's avatar
v-jincheng-msft
Icon for Community Support rankCommunity Support
2 years ago

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.