Get last value by data power bi

0

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.

    
asked by anonymous 22.10.2018 / 19:27

0 answers