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,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Thank you,
Pavan.