cancel
Showing results for
Did you mean:
Highlighted
New Member

## Formula for this?

Hey there!

I'm trying to deleveop a measure or column but am having difficulties figuring out how to approach the forumla. Basically, I'm trying to calculate the total % that something was out of stock.

Context:

In it's own table, our system records an entry every time something has a stock status change. The data is recoreded like this:

 sku date status sales category % sold ca0x1611 01/04/2017 out of stock 0.56 ca0x1611 03/28/2017 in stock 10.29 ca0x1611 02/25/2018 out of stock 9.24 ca0x1611 03/30/2018 in stock 10.02

To determine the total % of the sales curve that the item missed, I need to calculate the difference between the logged values. As an example, if I was trying to identify the out of stock % of the above item during the year of 2018, I'd take 10.29-0.56= 9.73%.

How would I structure my formula to calculate something like that? Thanks for the help!

0 REPLIES 0

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors