Forum Discussion
Don't sum an Inventory value
Hi, I have a situation with a matrix, where I am comparing plan vs Actual Inventory by month for 4 categaries. But when I select a whole year, the inventory values of all months get summed up...
Ashish_Mathur , Thanks for the response.
I have a scenario:
I will select November 2022 and save the file, and publish it in Power BI service. Next month, the filter will still be showing November 2022, rather than December 2022. It can become more tricky as January comes around where a previous year with 2 months earlier (November) data will be showing.
So, I was wondering if 'Plan Inv' could show same timeline as the 'Actual Inv' (which always shows current month, thanks to your .pbix file solution)?
This would alleviate my above issue.
Ashish_Mathur
Super User
Super User