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

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