filter tables by range of dates

[yoav20007]

I have only 2 tables and i want when i filter the first table it will filter other table between dates that in the first table.

i conect then with many to many relationship (maybe my mistake?) .

if it is posible to create a new table from table 2 just with the row in the rage dates that i select from table 1?

[Ashish_Mathur]

Hi,

Go to Data > Modelling > New Table and write this formula

=CALENDAR(MIN(Data[Planting Date]),MAX(Data[Harvest Date]))

Now build a relationship from the Date column of Table1 and Table2 to the Date column of the Calendar Table.

[yoav20007]

now i can do it manually . but how can i creat new table with the results automaticly?  

[MattAllington]

Here is a lot to learn when you start out. You should not creat this many to many relationship (there are exceptions, but this is not one of them).  You need another table containing all the uniqueness values containing both columns that you are joining on, and join both to that. Read my article here

https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/

Then this one

https://exceleratorbi.com.au/power-pivot-calendar-tables/

[yoav20007]

Thanks 

I try to connect them to 3 table that have unique values, but i still have a problem to filter by date from the first table.