Forum Discussion

Saqibmughal00's avatar
Saqibmughal00
Icon for Helper I rankHelper I
2 years ago
Solved

I wan to link multiple tables

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 ...
General Comment
Need Help
Show and Tell
Tutorial Requests
  • danextian's avatar
    danextian
    2 years ago

    Hi Saqibmughal00 

     

    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 ) )
danextian's avatar
danextian
Icon for Super User rankSuper User
2 years ago

Hi Saqibmughal00 

 

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 ) )
Saqibmughal00's avatar
Saqibmughal00
Icon for Helper I rankHelper I
2 years ago

Thanks, Thats what exactly I did and it sorted the problem