Forum Discussion
Solved
Dynamic Table Creation???
I've created some very simplfied mock data that hopefully explains what I'm trying to achieve for a user. Tables A & B are imported. Table C is a summarised from Table A, with columns added from Ta...
You are welcome.
Hi MJG2112, you could solve this by only creating a relationship between Table A and Table C. Table B would not have to be related to any other table. Then create the measures below and you are able to combine all of these in a single or multiple tables.
Total hours = CALCULATE( SUM(TableA[Hours]) )
Total ADJ = CALCULATE( SUM(TableC[ADJ]) )
With OT = CALCULATE( [Total hours] - [Total ADJ] )
Without OT = CALCULATE( [Total hours] - [Total ADJ], TableA[REG/OT] <> "OT" )
Hope this helps. If so, please give kudos 👍 and mark as Accepted Solution ✔️ to help others.