I have a price list like this
and I have a sell table
The final table should be like this
I have created a key-word "product_date" --> for example a_05/2020 or a_07/2020 but I don't know how connect key-words without connection.
Have you some ideas?
Thank you all
Go to Solution.
@giuliapiazza94 This is essentially Lookup Min/Max: https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434
So, in your case:
VAR __Date = 'SELL'[date]
VAR __Product = 'SELL'[product]
VAR __PriceDate = MAXX(FILTER('Table-Price',[product]=__Product && [date]<=__Date),[date])
MAXX(FILTER('Table-Price',[product]=__Product && [date]=__PriceDate),[price])
View solution in original post
@Greg_Deckler you are a genius 😊
thank you very much
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!