% Change Measure - last 7 days

[Jrich18]

Hi im looking to create a measure/measures that enables me to show the % change in price from the 2nd latest to the latest date.

my data is structured as so (date always 7 days apart):

Product|Date|Price

1 ,7th feb, 1

1, 14th feb , 2

1, 21st Feb, 3

 

so ideally it would show +33%. My data is a litle more complex in practice with multiple products.

i managed to make a function to return the latest date for that particular product, but not sure how to then return the price related to that date.

here is that function:

Max Date =   
VAR Uni = SELECTEDVALUE('Weekly Master'[Unique])  
RETURN MAXX( FILTER( ALL( 'Weekly Master' ), 'Weekly Master'[Unique] = Uni),
'Weekly Master'[Date]) 

thanks alot!

[Jrich18]

Hi @amitchandak,

thanks for the link to your video, it helped somewhat but im still stuck. 

Im not using a date table but i have calculated a date rank as a calculated comuln. When calculating Current Month i suspect it is summing all values for the date rank, not only values for the date rank for that particular product :

Current Month M = CALCULATE([Average Price Monthly], FILTER(ALL(Monthly),Monthly[Date Rank]= MAX(Monthly[Date Rank])))

The Average price monthly measure should be the latest value

Average Price Monthly =

CALCULATE(MAX(Monthly[Non-Forecast]), Monthly[Non-Forecast]<>0 && Monthly[Non-Forecast]<>BLANK())

Any help is appriciated. 

Thanks.

[amitchandak]

@Jrich18 , You can follow the rank approch, which I have used on my WOW blog

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8