Improving performance on comparing this year to last year chart

[ilana105]

Hello all,

I have created a couple of charts in which I show the YTD data of 2017 in columns and complete 2016. in line chart The thing is that, when I filter by date, I want to have the data from 2016 too, so I can always compare both years. In these pictures you can see the whole chart and the filtered chart:

Having this objective in mind, I created these two variables:

Revenue 2017 = CALCULATE([Revenue];FILTER(Table1;Table1[Date]>= DATE(2017;01;01) && Table1[Date] < TODAY()))

Revenue 2016 = [Revenue](DATEADD(DATESYTD(Table1[Date]);-1;YEAR))

[Revenue] is a measure that calculates the sum of revenue with a certain code.

It worked before perfectly, but had some lags in performance. However, I have loaded more data and now it's going extremely slow, and sometimes it even doesn´t have enough space in memory to load the data (see picture below)

Do you know any solution that could provide the same result and filter experience and at the same time improve the performance?

Thank you very much!!

[vanessafvg]

@ilana105 how much memory are you working with?  is this in imported mode?

[ilana105]

I have 8 GB and I am working with 4 tables mainly with 11 million rows, 5 million, 4 million and 2 million respectively. That graph is just one of the 5 that I want to create with the same logic: to be able to filter and see the first months of 2017, but at the same time I have in another column or line the value from the same month last year

[v-chuncz-msft]

@ilana105,

Is it possible to share the simplified version of your .pbix? It helps to analyze the problem.

[ilana105]

Hello,

How can I share the file? I have tried to upload it as a photo but I can´t

Thank you