Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 that when the reporting date changes the SLOB calculations update.
The shelf life difference between the manufacturing date and the expiry date, and the remaining shelf life is the difference between the expiry date and the date selected.
We will provide for items with less than 65% of shelf life remaining at reporting date, and would like to see the stock aged by shelf life intervals, >12 month shelf life remaining, 13-18 month Shelf life remaining etc
The calculation works ok when I have all the batch numbers selected, and can filter by 65% on SLR%, but I would like the data to show the SLOB at product level, and when I delete the batch, all items are filtered out.
I also want to be able to show the aging of SLOB in a table form by the month bands, which isn't possible by just filtering the SLR% measure in the filter pane.
I have created a table using the below, but it isn't dynamic, so when i change the reporting date (date slicer) the SLR doesn't update? Also, I am wanting to graph SLOB by week, but I am not sure of the measure to calculate the culmulative sum off all previous weeks?
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.
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
23 | |
10 | |
10 | |
9 | |
7 |