I'm trying to fit a DAX function to get the last value of a column from a Sales table based on the product code and a price table code.
For example I have a product that throughout the year had 3 prices in the same sales table at 022 for example. The prices were 30, 31 and 32. The last record I have on sale is 32 but my difficulty is in creating a measure to return only that last value despising the others. And this same product is sold in different price tables type 001, 002, 150 etc.