Forum Discussion
Building Relationships between Tables
I have two tables that both contain dates. Specifically, Month & Year. I want to add a slicer to be able to filter by Month and Year and it will update both tables accurately. I have built a Data table. I am trying to link both tables to the data table. However, It will not let me have two realtionships to the same data. How can I connect both tables to the data table?
1 Reply
Nick221_ , Create a date with help from month and year in both tables and join with date table, remove join between table
for text month
date = datevalue("01-"&[month]&"-"&[Year])
if month is number
date = date([Year], [month], 1)
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda
