Forum Discussion
Table Structure for Total Available Inventory to display in Stacked Column Chart Visual
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
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
1 Reply
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