Forum Discussion
Linking Two Tables with Multiple Entries
Solutions did not work as desired, in the end power query ammending the tables got a result that worked.
You need to create a data model
Create a Projects and an activities Table
Projects =
DISTINCT
UNION (
ALLNOBLANKROW ( Table1[project] ),
ALLNOBLANKROW ( Table2[project] )
)
Activities =
DISTINCT
UNION (
ALLNOBLANKROW ( Table1[Activity] ),
ALLNOBLANKROW ( Table2[Activity] )
)
Connect each of them one to many to your Table 1 and Table 2
Define two measures
Budget = SUM ( Table2 [Budget Labor Hours]
Actual = SUM ( Table1 [Hours] )
and drop both of them into the values section of the matrix
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Not quite getting it to work.
The actual is now a sum of all activities not each one.
I am not sure where the two measures should have been made, or how the actual measure would sum up each activity? I feel more needs to be done there?