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
mahoneypat
Microsoft Employee
Microsoft EmployeeThe 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