Forum Discussion

ArvindJha's avatar
ArvindJha
Icon for Helper III rankHelper III
1 year ago

Create a single table many to many relationship using DAX

Hi all,   I want to create single table out of two tables with many to many relationship using DAX , LOOKUP and RELATED does not work. For time being i have created relationship between them but i...
Need Help
olgad's avatar
olgad
Icon for Resident Rockstar rankResident Rockstar
1 year ago

Cant you just merge them in the Power Query? full outer join? 

Or alternatevely,

CombinedTable =
SELECTCOLUMNS(
FILTER(
CROSSJOIN('Visits', 'Height'),
'Visits'[PERSON] = 'Height'[PERSON]
),
"PERSON", 'Visits'[PERSON],
"VISIT", 'Visits'[VISIT],
"WEIGHT", 'Visits'[WEIGHT],
"HEIGHT", 'Height'[HEIGHT]
)

 

 

ArvindJha's avatar
ArvindJha
Icon for Helper III rankHelper III
1 year ago

Hello Olgad , it works i needed one input , here i just shared sample data with only 4 columns but in reality i have 20+ columns , so do i need to write 20 lines (one for each column) or is there a way it takes all columns automatically using * or something that would be helphul in such scenarios

  • ArvindJha's avatar
    ArvindJha
    Icon for Helper III rankHelper III
    1 year ago

    Hello Olgad , thanks for the response also to your question on join why i am not taking join is that there are some transformations which is making m-query very slow so i doing them in DAX which is fast and then unable to move back to m-query as those newly created tables using DAX are not visible in m-query