Forum Discussion
linking two tables
Hello, I have two tables that I want to link together, but I don't know how to do it correctly. Because in table A there are different phases per ID with a start date (start of the phase). In table...
lua2 , Not very clear, but you need a common date and projectid column
refer if needed - https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda
Hi amitchandak,
I would like to be able to have a relationship built between the tables so that if I were to have 2 tables/matrices in the Report view, with one table showing the Daily Date Data and the other table showing the Ranged Data Data, I would be able to select a record in the Daily table and Power BI's highlight functionality would filter the records in the Ranged table so that only date ranges containing my selected date appear, and vice-versa
.