Forum Discussion
ddbaker
Helper I
Helper IMeasure Calculations are Really Slow
Hey everyone, I have several measures that I'm using that are really slowing my report down. Wondering if any of you can provide any tips to make them more efficient. ARR (Monthly) =
VAR ...
The simplest approach would be to modify your Subscriptions table and append it to your invoices table, so it looks something like this. I just added an Invoice Date to it with Date.From(DateTime.LocalNow()), and renamed the Amount column.
Simpler model leads to much simpler DAX.
Pat
lbendlin
Super User
Super UserDump the DATESBETWEEN filters - the majority of them can be replaced with [date]< [last calendar date]
Look into using LASTNONBLANK
Look into using MAXX or similar aggregator functions
Use DAX Studio to evaluate your query plans.
If you like more help please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.
