Hello everyone,
I would like to find a way to match historical prices according to sale date ranges
These are my tables.
Thank you all.
@maxfabian16 I created a similar model in PowerPivot and came up with a DAX measure "LastPrice" that does what you need. Please see attached.
By the way, your screenshot looks like you are working in PowerBI. If so, you could simplify the measure by using SELECTEDVALUE rather than IF and HASONEVALUE, although I'm a little bit out of my comfort zone here. There may be better ways to do it.