Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

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...

Tips and Tricks

Ashish_Mathur
3 years ago
Hi,

You may download my PBI file from here.

Hope this helps.

Icon for Super User rank

Super User

3 years ago

Hi,

Share the download link of your PBI file and show the expected result very clearly.

Anonymous
Not applicable
3 years ago
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.

https://github.com/Adityadambal/PowerBI/blob/c11e19e34563f036bef3399bdf0e915eb5b3a125/Inventory%20Plan%20vs%20Actual.pbix
- Ashish_Mathur
  Super User
  3 years ago
  Hi,
  
  You may download my PBI file from here.
  
  Hope this helps.
  - Anonymous
    Not applicable
    3 years ago
    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?

Related content