Forum Discussion

lm_suresh's avatar
lm_suresh
Frequent Visitor
1 year ago
Solved

Dynamic table based on values from 2 different tables

Hi This is my Table structure.    Table 1     Table 2     No Item   No Subcat DES 1 A   1 CAT1 AAA 2 B   2 CAT2 BBB 3 C   3 CAT3 CCC 4 D   4 CAT4 DD...
Need Help
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    lm_suresh For this, you can first create a calculated table in Power BI by loading both Table 1 and Table 2. Then, use the DAX function GENERATE to create all possible combinations between the two tables. Next, you can add any additional columns like a sequential number or other needed columns using DAX functions like ADDCOLUMNS. Finally, use this new calculated table in your visuals to display the dynamic relationships between the values.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi lm_suresh,

Thank you for reaching out in Microsoft Community Forum.

Thank you ryan_mayu , Akash_Varuna    for the helpful response.

As suggested by ryan_mayu, Akash Varuna.,  I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.

Please continue using Microsoft community forum.

Regards,
Pavan.