Forum Discussion
Solved
DAX - Variable Measure between two Fact Tables
Hello, I am attempting to display Scheduled hours in the same table as Sales and Checks per hour. The Sales table is a direct query to a data lake enviroment, and the Scheduled hours is an excel ...
Yes your relationships (primary key columns) will not work if your matching on day of week. Since there are multiple records in fact tables for each day of the week, it sums them up. If you modify your date table to the interval level then match on that key, the measures will calculate at the appropriate level.
Yes your relationships (primary key columns) will not work if your matching on day of week. Since there are multiple records in fact tables for each day of the week, it sums them up. If you modify your date table to the interval level then match on that key, the measures will calculate at the appropriate level.
Thank you again for the response. This was exactly what I needed (adding the intervals to my dim date table).