Forum Discussion
Lookupvalue from Grouped Table want to return Aggregate Value
I have a large table of all my schedule updates. Each monthly schedule update contains the same schedule activity so the table has multiple times rows of the same activity (20 or more as i add updat...
healthEteam
Resolver I
Resolver IDid you create the relationship on activity id between the two tables?
If so I would think you could use the Related function to retrieve the columns from aggregate table into the original.
Yes i had the link it through another table because the Activity ID columns were not unique in the Monthly Excel Export tanle..
- healthEteam
Hmm is activity id not unique in your summarized table?
I would have thought it would be and then you could create the relationship to the excel based table.
Then in dax use the Related(Finished_Min) to add your column into the original table.
