LOD calculations are typically easier and faster to work with than table calculations so I would use those if possible.
Does that help?
Thanks for the response Patrick.
Sorry for the confusion, but I actually was wondering if it was better to have extra columns in my SQL database, or to have fewer columns but just use an LoD calculation to get the same result.
I'm really struggling with performance issues, but can't use an extract. 20-30 seconds to refresh a dashboard each time a small filter adjustment is made is quite painful.
Any advice? Should I look into changing something on the SQL/database side? Is there a way to 'pre-load' all the data? I've tried pausing auto-updates but it doesn't help much.
It would be nice if there was a live/extract hybrid where I had a live connection, but it only updated every 24 hours or 7 days.
You can schedule your workbooks or extracts to update whenever you want - every 24 hrs, once a week or even once every five minutes, the sky is the limit. I'm not sure what the issue is for you in using extracts.