Forum Discussion
Solved
Date Filter
Hello everybody, my report in Power BI Desktop currently consists of 2 excel sheets that are linked by a relationship (m:n) with double-sided cross-filter direction. The common criterion is the “...
Hi HT123 ,
I replicated your sample data, created a date table, and created a dim table for orders like so:
I did not create a relationship between table A & B on Orders, instead I created a relationship of each table with the dim order table above.
I created a simple measure in each table:
Total Qty = SUM('Table A'[Quantity])Total Time = SUM('Table B'[Time])This is the result:
Hope it helps!
Regards,
Fernando