Hi I've created an Excel sheet with 100 or more DAX measures.
When I update they all get calculated and it takes about 5 minutes.
Will more measures slow it down even more?
I've also converted some PIVOTTABLES to OLAP CUBEFUNCTIONS. How does that effect the speed and processing of the sheet.
This is a huge project that about 100 staff member will be using everyday. So performances and memory management is important.
Thanks
When I update they all get calculated and it takes about 5 minutes.
Will more measures slow it down even more?
I've also converted some PIVOTTABLES to OLAP CUBEFUNCTIONS. How does that effect the speed and processing of the sheet.
This is a huge project that about 100 staff member will be using everyday. So performances and memory management is important.
Thanks