Forum Discussion
Dynamic SLOB table using existing measures
Hello, I am trying to calculate slow moving obsolete stock, which I have done by calculating the shelf life remaining for each batch based off the slicer date. I would like this to be dynamic so...
I am not sure if this is the best approach as I have a large dataset, so when I try to use a DAX virtual table the "visual exceeds resrouces error"shows.Have a look at the query that is produced for the virtual table. There are good videos on SQLBI.com on how to refactor queries to reduce cardinality quicker, and use fewer resources. You may even be able to get away with separate measures that are optimized for each cell in the result table.