Forum Discussion

ben_w's avatar
ben_w
Frequent Visitor
7 years ago

Cumul sum performance improvements

Hi I'm using PBI with DirectQuery to SSAS Tabular 2016 standard. Scenario: Costs per project, sliceable by time, for current value and total project value, up to the chosen date. Curre...
Need Help
Tips and Tricks
ben_w's avatar
ben_w
Frequent Visitor
7 years ago

 

Thanks for the explanation.

I have extensively tried the parameters suggestion, it unfortunately does not result in faster times. Not worse either though, exactly the same.

Iit seems that even though it evaluates each row, it does not compute each time the max(), hance no improvement with parameter.