Re: Optimizing a column calculation

aaelansr — Sun, 26 Nov 2023 15:49:51 GMT

Greg_Deckler Great! That worked beautifully and enabled me to process more than twice as many rows, but still didn't get me all the way. Can you help me with what this would look like using SUMMERIZE? Would SUMMERIZE also use up less memory?

Thank you!

Optimizing a column calculation

aaelansr — Tue, 21 Nov 2023 14:30:23 GMT

Hi, I have a dataset thats has 11m rows and I am trying to add a column to run a sumX that will then be used in a different column but this calcualation keeps running out of memory. The calculation won't even run on a third of the dataset.

sumX (

FILTER (

ALL ( 'Master' ),

Master[Observe] <= _CurrentYear

&& Master[Observe] > _MinYear
&& _Asset =Master[Building-Asset]

([Amount to be Depreciated]*Master[Percentage]*Master[Period of Depreciation])/Master[Total Number of Months]

))

Are there ways to optimize or rewrite this calculation to reduce the memory usage and have it work?

Thank you!

aaelansr Tracker

Re: Optimizing a column calculation

Optimizing a column calculation