evolution of the stock month per month

[celantjm]

Hi all,

I have a problem. I need to follow the evolution of the stock month per month (in a TBT).

But I don't find a command which function :

- My PowerBi is directly in link with de DB. each product is a row in the DB and there are a date-column for the introduce in the stock and a date-column for the end in the stock. The last column is empty when the product is always in the stock. When the product get out, a date is introduce.

My problem is then : I want, for exemple, find in my TBT, the number of product in the stock month per month (the product introduce before or during the date of view (last day of the month) without date of out or with a date of a next month.

Do you have a solution ?

Thank you.

[Anonymous]

Yeah... I would probably have a solution if I was able to understand the problem. As long as you're not able to clearly state the problem and give enough background, I wouldn't count on any answers.

Best

Darek