Forum Discussion
Pivot Tables
rdwmatt First you need to create a relationship between the two tables in the Data Model. Then you also need a few DAX measures that let you summarize the hours by Employee and calculate the overall Allowance and Allowance Remaining.
I've done that in the attached file.
Thank you.
rdwmatt I'm sorry, but a step-by-step guide explaining how it all works goes beyond the scope of my involvement in this user forum. I don't have time for that.
But you could invest some time yourself learning basic DAX. Learn what measures are and then use on-line resources to read about the functions used in my examples. Though, be prepared that DAX is far from intuitive or user friendly. At least, that's my personal opinion. It takes a considerable effort to master it. An I am still a long way away from that point.
Thank you, I appreciate the help. I will look into DAX and study up.