Forum Discussion

Olwin's avatar
Olwin
Frequent Visitor
4 years ago

Inventory Beginning and Ending Balance

Hi there,   I want to create a measure that shows Beginning Balance and Ending Balance of my Inventory. I have 2 tables: Master Item and Inventory Transaction. Here are my sample data:   Master...
Need Help
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Hey Olwin ,

 

what exactly is not working?

You don't need a second date table that is not connected to any other tables. As I mentioned in the last reply, you have to set the filter direction between date table and VE table to "single". Then the report is working properly.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
Olwin's avatar
Olwin
Frequent Visitor
4 years ago

Hi selimovd ,

 

The result is not the same as my initial expectation.

Herewith I send you my .pbix file. I have followed your guidance to set filter direction to "single". Kindly please take a look.
Sample pbix file 

Thank you.

 

Best regards,

Olwin