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.
Good Tuesday from Italy for all readers of the forum & apologize for my bad English
from my datawerehouse i export two tables:
Sales
Product
i have created a CalendarTable to filter my data by Year/Month
BUT
if i want to create a filter in my report for "agente" (sales vendor) connected to both table (Sales & Product)
what i have to do ?
i have to create another table ?
Solved! Go to Solution.
Hi @mammifero,
Yes, I think you need to create 'agent' bridge table based unique agent id from three tables.
Tables which you listed on snapshots are linked with date key. If you create relationship with one table on agent id, it will filter current table with agent id and use related datekey to filter another table.
Regards,
Xiaoxin Sheng
Hi @mammifero,
Yes, I think you need to create 'agent' bridge table based unique agent id from three tables.
Tables which you listed on snapshots are linked with date key. If you create relationship with one table on agent id, it will filter current table with agent id and use related datekey to filter another table.
Regards,
Xiaoxin Sheng
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |