Fixed... no idea what caused it but restarting the 2019 instance has fixed it.

Thanks for the replies guys, much appreciated. 

I've tried adding the suggested index, so I'll have to wait and see how that goes.  The statistics on the database...

Putting GO statements rather than semicolons after each statement seems to work...

Thanks Brian for your reply. 

That sounds feasible, however the problem I'm having is with the coding of the YoY measure itself in the tabular model as I'm...

I think have a working solution now.

I've built a table to capture the lsn.  In my initial load package, the first thing it does is to construct the...

Thanks guys.

You could take a more dynamic approach and cross join your locations with your months to get all possible combinations of location / month, and then left join your original...

Thanks Philip for your reply, I see what you're saying. I haven't had much of a chance to play with this recently but I will certainly try Ninja's index...

Thanks guys for the speedy responses. I think it's actually a parameter sniffing issue - if I hard code the dates into the WHERE clause then I get the...

FYI. Please see reply below (from MSDN) from Erland Sommarskog, SQL Server MVP. Thanks.

"Did you inspect the query plan to ensure that the view is actually being used?

When...