Maximize Sales Using Sales Price and Lbs Sold History

Question

I would like to find out what my best LBS to Sale Price ratio is.&nbsp;&nbsp;I have very detailed sales history but to put it simply, it looks like this:&nbsp;Product Code &nbsp; &nbsp; Sold Price &nbsp; &nbsp; LBS Sold &nbsp; &nbsp; &nbsp; Invoice Date12345 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$5.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100.00 &nbsp; &nbsp; &nbsp; &nbsp; 1/5/1712345 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$4.95 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;110.00 &nbsp; &nbsp; &nbsp; &nbsp; 2/3/1712345 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$7.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;54.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2/14/1712345 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$5.10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;110.00 &nbsp; &nbsp; &nbsp; &nbsp; 2/18/17&nbsp;I THINK I want to have a graph that shows a Min&nbsp;Sold Price/Max Sold Price line on top of an area chart that shows the LBS sold at that price.&nbsp;&nbsp;The idea is to know the price when my sales would start to diminish, particular during certain seasons.&nbsp;&nbsp;Any help or thoughts would be appreciated! I'm open to any ideas as well as I may be completely off with what I need.Thanks!R

anonymous · Accepted Answer

You could have Power BI Create a custom column which holds the LBS to Sale ratio. Create a formula like:

LbsToSale = [LBS Sold] / [Sold Price]

Now you have a list of Dates, product codes and pound to price ratios. If you graph this, you can then start to see where your best and worst points of time are.

Forum Discussion

Maximize Sales Using Sales Price and Lbs Sold History

2 Replies

Related content

Filtering Record History by Period

forecasting sales based on history

History Data in Direct Query

SharePoint Version History

Trouble scraping SharePoint Version History