Forum Discussion
Dynamic table based on values from 2 different tables
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.
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.