Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 person is associated to the rate. I've written a calculated column that correctly pulls the sales person from the rates at the time of the quote (QuoteDate).
This answers the question "Who was the sales person for a given rate at the time of the quote?"
Here is my calculated column:
Again, this works, but it seems very slow. It takes about 4-5 minutes of spinning on my desktop. The dataset is only about 120k rows.
My question: is there is a better/faster/easier way to do this? The performance just seems so slow.
Thank you!!
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?
Actually, 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!
User | Count |
---|---|
89 | |
75 | |
69 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
74 | |
60 | |
59 |