Using Power BI for Inventory/Capacity Reporting

[irnm8dn]

I am looking for some creative ways to represent inventory or capacity using Power BI.  I presently have a dataset that shows me Campaigns, Campaign Dates and Products Sold.  The data set, through Power BI, currently serves as a reference to salespeople who want to know what's been sold, when and in what market.  

I would like to take this report to the next level, by showing if there is more "inventory" to be sold.  

Problem Statement

The challenge is that the data set does not have any notion of "capacity"... Meaning that there is no reference point within the data to determine if there is an opportuntity to represent when inventory is Available or SOLD OUT.

Proposed Solution (in business terms)

• When Product Name is "A" or "B" or "C" or "D" or "E" then SOLD OUT, else Available

Looking for any suggestions on how to add this logic based column, or other creative ways some of you may be using Power BI to represent inventory.

Thanks in advance.

[v-yuezhe-msft]

Hi @irnm8dn,
 
I am not sure what is your expected result, do you have a ProductName field in your table? If you have, you can add another new column using the following formula to represent if you have Available or sold out item based on the above business logic.

Column = IF(Table[ProductName]="A" || Table[ProductName]="B" || Table[ProductName]="C" || Table[ProductName]="D" || Table[ProductName]="E","Sold out","Avaliable")

However, your business logic looks a little weird for me, generally, could you please share sample data of your table and post desired result here? And you can review the following similar blog about what fundamental data tables we should have and how to calculate inventory using DAX in Power BI.

https://www.sqlbi.com/articles/inventory-in-power-pivot-and-dax-snapshot-vs-dynamic-calculation/
 
Thanks,
Lydia Zhang