Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
now i can do it manually . but how can i creat new table with the results automaticly?
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/
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |