Forum Discussion
watje255_ju
Helper III
2 years agoDynamic 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...
lbendlin
Super User
2 years agoI 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.