cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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:

skudatestatussales category % sold
ca0x161101/04/2017out of stock0.56
ca0x161103/28/2017in stock10.29
ca0x161102/25/2018out of stock9.24
ca0x161103/30/2018in stock10.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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

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