Forum Discussion
Don't sum an Inventory value
Hi Ashish_Mathur , Thanks for replying. I have attached link for my github which has the .pbix file.
My preferred outcome is:
1. When the Matrix appears, I want it to show latest month's inventory. And I should be able to select a specific month from the filter to see that month's inventory.
Hi Ashish_Mathur ,
Thanks for the solution. Just one modification needed.
My 'Plan Inv' shows inventory of December 2022, while my 'Actual Inv' shows inventory of the current month when no date filter is selected.
Is there a way 'Plan Inv' can show data of the month of 'Actual Inv' when no filter is selected?
You are welcome. Why not maintain the discipline of always select a year or year and month?
Yes, since date is floating value (i.e., Every Month new data), I would like to have one new month data appearing on the table.