3 Replies Latest reply on Sep 4, 2018 10:44 AM by Jim Dehner

# Identify change in a Measure Based on Dimension

Hello,

I am trying to identify which Part Numbers have had an increase or decrease in their sell price since they were first sold (date). Ideally, a new dimension can be created that identifies this.

So far I've been close by using MIN/MAX LODs with IF statements but haven't quite got there. Attached is a workbook.

 Part Number Order Date Sell Price 123A 10/1/2017 \$10.00 123A 10/5/2017 \$10.00 345B 10/4/2017 \$5.00 345B 11/15/2017 \$7.00 345B 11/16/2017 \$7.00 678C 10/1/2017 \$8.00 678C 12/10/2017 \$6.00 901D 10/3/2017 \$100.00 901D 10/5/2017 \$100.00 901D 11/14/2017 \$100.00 901D 11/19/2017 \$105.00

In the sample data above, part numbers 345B and 901D would be identified as a part numbers with a "Price Increase" being they have increased. Part number 678C would be "price decrease". The remaining can be identified as "no price change"

• ###### 1. Re: Identify change in a Measure Based on Dimension

see the attached - there are 2 approaches

one uses lookup the other uses LOD's

the Lookup looks like this

and returns this

the LOD avoids the need for a table

this is the intro date

intro price

and this assigns the label

and it can return this (not table necessary)

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful
• ###### 2. Re: Identify change in a Measure Based on Dimension

Jim, Wow thanks for the help. It looks like I was over complicating my LOD and tried to make it as one LOD but breaking it out into three as you did it works perfectly.

I havent tried the LOOKUP as I wouldn't need a table. Thanks!