Forum Discussion
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...
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.
