Memory Error

[Anonymous]

Hi @v-juanli-msft ,

This is in continuation to the solution you provided for my post:

https://community.powerbi.com/t5/Desktop/Can-we-have-this-Dynamic-instead-of-Hard-code/m-p/747278#M3...

your code worked well when we have a small data.  

I now added the similar other critierias in the same code which went really very long since we have multiple criterias in this. I now get this Memory error:

Since my Material type is alwasys going to be ZHWA, can we have it common somewhere instead of repeating it several times.?

I believe this should solve the memory error.

Or any other alternative would be  greatly appreacited!

Thanks,

Tejaswi

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may take a look at the links below.

• Best practices for building fast and reliable reports
• https://www.sqlbi.com/topics/optimization/

[Anonymous]

Hi @v-chuncz-msft ,

These documents are indeed very helpful. 

Using Var function resolved my memory issue.

Thanks,

Tejaswi