Forum Discussion

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

Connect two tables in a view without relationship

Hi community. Do you know if/how can I do this? I have two tables that are part of different pieces in the data model. They do not have a relationship in place. The two tables have a common column. I...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi RRSSDW ,

    Please try to merge these two table with the common column to a new table, then use the new table to visualize.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

RRSSDW's avatar
RRSSDW
Icon for Helper I rankHelper I
2 years ago

I understand the need to have useable data rather than screenshots. My question is quite generic and stays at general knowledge level DAX to visuals. Sample data would be like this picture. passing via text, but not sure it works and not sure it adds value

Table1
Column1 Column2 Column3 Column4
aaa x1 zzz xx
bbb x2 zzz xx
ccc x3 zzz xx
ddd x4 zzz xx
eee x5 zzz xx
fff x6 zzz xx


Table2
Column1 Column5 Column6 Column7
aaa y1 b1 sd
aaa y2 b2 sd
aaa y3 b3 sd
fff y4 b4 sd
fff y5 b5 sd
fff y6 b6 sd