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
ArvindJha's avatar
ArvindJha
Icon for Helper III rankHelper III
1 year ago

Hi Olgad , thanks for response , it doesn't work 

 

olgad's avatar
olgad
Icon for Resident Rockstar rankResident Rockstar
1 year ago

Person shall be the common column, check if it is the same datatype sometimes when one is string/text and the other is 'any' or different spelling person Person or there is a space in the name of one then it doesnt work

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

    The name and datatype both are same , the 1st solution of CROSSJOIN works the only challenge is i have 30+columns and i need to enter 30 rows for that , is there any alternative to writing 30 rows?