Stock Counting Month-by-Month

[Mheadland]

Hi all,

I am currently trying to build a stock report and I need a stacked column chart that shows month by month what we have in stock. In order for something to be counted as stock it needs to "WS" before the start of a month and "R" on or after the start of a month.

Currently, I have 48 individual calculations like this:

and I am wondering if there is a formula I could use to automate this so I don't have to do every month individually. 

I am hoping to get a final product that looks something like this:

but currently I am not sure if this is even possible due to the fcator of needing to filter each column for specfic dates. 

Please could anyone support me with this?

Thank you in advance for your help!

[Anonymous]

Hi @Mheadland ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Ritaf1983 · Accepted solution]

Hi @Mheadland 
It seems weird that you have to create individual logic for every column.
It seems that you just have to create the right data model with dimensions tables,

take a look at the linked tutorials:

https://www.youtube.com/watch?v=islhUWaCiJ0&t=3449s

https://www.youtube.com/watch?v=1Z_f6jkjprM

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly