Hi @DRNEWTR I suspect that you are trying to capture the invoice date when the purchase price is changed for each product. I sorted the data by Recid and created a calculated DAX column to get your desired results. See the attached .pbix file.
Last Purchase Change Date (DAX) =
VAR CurrentRecid = 'Table'[Recid]
VAR CurrentPrice = 'Table'[Purchase_Price]
VAR CurrentProduct = 'Table'[Product_Number]
VAR PreviousPrice = CALCULATE(
LASTNONBLANK('Table'[Purchase_Price], 1),
FILTER(
ALL('Table'),
'Table'[Recid] < CurrentRecid
&& 'Table'[Product_Number] = CurrentProduct
)
)
RETURN
IF(
CurrentPrice <> PreviousPrice,
'Table'[INVOICE_DATE],
CALCULATE(
MIN('Table'[INVOICE_DATE]),
FILTER(
ALL('Table'),
'Table'[Recid] < CurrentRecid
&& 'Table'[Purchase_Price] = CurrentPrice
&& 'Table'[Product_Number] = CurrentProduct
)
)
)
Did I answer your question? Mark my post as a solution!Proud to be a Super User!
