From your description, it sounds like this is primarily a data modeling problem. I don’t think your Shop table is a fact table, but instead a dimension table with a slow changing dimension (date of last refit). Also want to look at how you have your date table set up and marked. I don’t think this is going to be difficult to fix, but if you could please post your PBIX with fictitious data/names substituted for anything sensitive, that would be a huge help in getting this resolved.
- Brian