Forum Discussion

Abbi's avatar
Abbi
Helper I
4 years ago
Solved

How to create a custom table or Matrix table

Hi All, Looking forward for your help. I have 2 tables, Table1 and Table 2. Table1 - ID Depedency Owner 1234 Client Maruti 1234 Testing Maruti 1234 Engg Maruti 8125 Suppor...
  • Icey's avatar
    Icey
    4 years ago

    Hi Abbi ,

     

    Please check this:

     

    Detail steps:

    1. Create two tables.

    ID = 
DISTINCT ( UNION ( DISTINCT ( Table1[ID] ), DISTINCT ( Table2[ID] ) ) )

    Depedency = 
DISTINCT (
    UNION ( DISTINCT ( Table1[Depedency] ), DISTINCT ( Table2[Depedency] ) )
)

     

    2. Create relationships.

     

    3. Create a Matrix.

     

     

    For more details, please check the attached .pbix file.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Abbi's avatar
Abbi
Helper I
4 years ago

Thanks ValtteriN  for the post, your post doesnt solve my issue, as my clients export the data to csv, they dont want 2 tables. 

 

If you have any better view other than table please suggest, where i can show them the difference in the dependency  against the ID's 

  • Icey's avatar
    Icey
    Community Support
    4 years ago

    Hi Abbi ,

     

    Please check this:

     

    Detail steps:

    1. Create two tables.

    ID = 
DISTINCT ( UNION ( DISTINCT ( Table1[ID] ), DISTINCT ( Table2[ID] ) ) )

    Depedency = 
DISTINCT (
    UNION ( DISTINCT ( Table1[Depedency] ), DISTINCT ( Table2[Depedency] ) )
)

     

    2. Create relationships.

     

    3. Create a Matrix.

     

     

    For more details, please check the attached .pbix file.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.