Previous price

[MRR]

Hi All,

Tried to find a solution but I cannot seem to find it.

I got this tabel:

T_DossierDetail
Partcode	Pricedate	PriceCustld	Currprice
A	1-1-2020	10000	100
B	1-1-2020	12000	200
C	1-1-2020	10000	300
D	1-1-2020	12000	400
A	2-2-2020	10000	150
B	2-2-2020	12000	200
C	2-2-2020	10000	300
D	2-2-2020	12000	450
A	3-3-2020	10000	150
B	3-3-2020	12000	250
C	3-3-2020	10000	350
D	3-3-2020	12000	450

I have a measure for last price by month

Price month 03 = CALCULATE(MAX(T_DossierDetail[CurrPrice]),'date'[Month]=3)

What I'm looking for is a formule for previous price, so partcode A actual price is 150 and I would like a colum/measure, that gives me a result of 100, because that is the previous price.

To make it even harder I would like to have it on partcode and pricecustId.

Anyone?

[amitchandak]

@MRR , Try a new column like

new column =
var _max = maxx(filter(table, [Partcode] = earlier([Partcode]) && [Pricedate] <earlier(Pricedate)),[Pricedate])
return
maxx(filter(table, [Partcode] = earlier([Partcode]) && [Pricedate] =_max ),[Currprice])

Refer last noncontinuous date logic in this blog for measure

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...