Table Structure for Total Available Inventory to display in Stacked Column Chart Visual

[ycavazin]

Hi,

I have a table that looks like this:

id	creation	update	status
1	January	January	created
2	January	January	created
3	January	February	Done
4	February	February	InProgress
5	February	March	Done
6	February	April	Done
7	March	May	Done
8	March	March	InProgress
9	June	June	created
10	July	August	Done

I want this table to look like this:

Month	Created	Closed	Available
January	0	0	3
February	3	1	5
March	2	1	6
April	0	1	5
May	0	1	4
June	1	0	5
July	1	0	6
August	0	1	5

so I can create a visual like this:

Can someone please guide me?

Thanks.

Yuri

[v-lili6-msft · Accepted solution]

hi, @ycavazin 

You may refer to this post:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

For your case, just create three measure for created, Closed and Available by adding a conditional in the formula.

If you still have the problen, please share your expected output based on the sample data.

Best Regards,

Lin