Forum Discussion
Solved
help with find data thru dates
hi, i have two tables the first is "itemlist" that contain two columns: itemnum, date of price , price for example: iphone - 2.6.17 - 15$ iphone - 9.6.17 - 15.5$ iphone - 10.6.17 - 19$ t...
You can also achieve it via DAX approach.
Make sure there's no replationships between both tables. You can create a calculated column in Order table to get the Latest Release Date from item list table.
Latest Release Date = MAXX(FILTER(ALL('itemlist'),'itemlist'[Date]<=EARLIER('Order'[Date]) && itemlist[Item]=EARLIER('Order'[Item])),itemlist[Date])Then use LOOKUPVALUE() to get corresponding Price.
Latest Price = LOOKUPVALUE(itemlist[Price],itemlist[Date],'Order'[Latest Release Date],itemlist[Item],'Order'[Item])
Regards,
thank you very much!!!!!!
its work for me. great!
thanks.
i have some orders with a date before the first date on the itemlist table, in this situation the lookupvalue intreduse "0".
i whant him to intreduce the first price from the first date that exist in itemlist table.
please help me.
thanks.