Forum Discussion
Solved
Fetch Cost Price based on Sales Date
Hi everyone, I receive cost price lists from a factory every six months (or more, occasionally) in an Excel file. I also have an output from our accounting software with the sales per order. I im...
QPV , Assume Cost has cost price with date, item and sales has sales date ans item
then a new column in sales table
=
var _max = maxx(filter(Cost, cost[Item] = sales[Item] && cost[Cost Date]<= sales[Sales Date]), COst[Cost Date])
return
maxx(filter(Cost, cost[Item] = sales[Item] && cost[Cost Date]=_max), COst[Cost Date])Change as per need
amitchandak
Super User
Super UserQPV , Assume Cost has cost price with date, item and sales has sales date ans item
then a new column in sales table
=
var _max = maxx(filter(Cost, cost[Item] = sales[Item] && cost[Cost Date]<= sales[Sales Date]), COst[Cost Date])
return
maxx(filter(Cost, cost[Item] = sales[Item] && cost[Cost Date]=_max), COst[Cost Date])
Change as per need
Thank you very much, this worked!