Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I got a situation, got planned data at different sheet and actual at different sheet. both are linked to date table but I also want to link them based on "adjusted scope" as the slicers are based on that. Shall appreciate your support on that. attaching screenshot below for reference. Force allocation data is actual file while planned is plan file and both have common adjusted scope. An i am keen on one to many relation (not sure if others will work as never tried).
Solved! Go to Solution.
You can create a separate dimensions table to link the two tables just like you did with dates. You can do that either in the query editor or in DAX. In DAX, try this:
DimScope =
VAR __FORCE =
SELECTCOLUMNS ( 'Force Table', "Adjusted Scope", 'Force Table'[Adjusted Scope] )
VAR __PLANNED =
SELECTCOLUMNS ( 'Planned', "Adjusted Scope", 'Planned'[Adjusted Scope] )
RETURN
DISTINCT ( UNION ( __FORCE, __PLANNED ) )
Proud to be a Super User!
You can create a separate dimensions table to link the two tables just like you did with dates. You can do that either in the query editor or in DAX. In DAX, try this:
DimScope =
VAR __FORCE =
SELECTCOLUMNS ( 'Force Table', "Adjusted Scope", 'Force Table'[Adjusted Scope] )
VAR __PLANNED =
SELECTCOLUMNS ( 'Planned', "Adjusted Scope", 'Planned'[Adjusted Scope] )
RETURN
DISTINCT ( UNION ( __FORCE, __PLANNED ) )
Proud to be a Super User!
Thanks, Thats what exactly I did and it sorted the problem
It looks like Adjusted scope is just a text field? I would suggest you need an adjusted scope table and join it to both tables, like you did with date.
The easiest way to do this would be in Power Query.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |