Forum Discussion
hyggins
Helper I
Helper IPerformance question about looking up a value between two dates
I have two tables: Quote and Rate related by QuoteId (see image). A quote can have multiple rates but only one can exist at any given point in time as determined by Begin and EndDates. The sales pers...
Think the issue here is that you are using Filter on a Fact table, which is generally bad for performance. Any chance you can upload some sample data?
hygginsHelper I
Helper IActually, neither of these are fact tables. No measures are defined. The Rate table is only needed to define the SalesPersonId on the Quote table. The Quote table is then used as a dimenision for a larger dataset (not shown). This is a simplified example for the post.
And I have the Quote and Rate table data available here: sample data file
Thank you!