Forum Discussion
Solved
Creating Calculated Table with hierarchies
Hi I have a table of invoices containing 18M records, and about 10K of products and 30 different Sales Branch. when I create measures like MTD and Previous MTD and use them in visuals it is very slo...
SamSP , You need to use aggregations
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-aggregations
If needed join it back with branch and product.
SamSP , You need to use aggregations
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-aggregations
If needed join it back with branch and product.