Forum Discussion
Solved
Average value from second table
Dear All, I am sure my question is very basic. I have 2 tables: - PreviousMonth, in which i get the hours and amount for each persons (1 line per date) - ThisMonth, in which I get the hours done ...
Make sure your Relationships are set to BOTH for 'Cross Filter Direction' since you are passing thru the ID table to get data from another table. Also, I tried this less complex Measure allowing ID to be calculated based on the table values instead of forcing the filter (but I think your code works as well).
FOrrest
