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.
Hi lm_suresh,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as Solution" and give a 'Kudos' so other members can easily find it.
Thank you,
Pavan.