How can I show latest Price, with DAX?

[Anonymous]

Hello,

I have some sample data below the prompt. I have to create a dax measure from this, any thoughts? Thank you!

• Customer's Latest Price for specific item in the last 180 days

• If latest price is less than the Retail Base Price (which is column from seperate tabe), then show the Retail Base price.

• If price is blank (as having no sales history in  last 180 days), then show Retail List Price.

• If customer's latest price (or product of this formula) is greater than Retail List Price (column from seperate table), show Retail List Price.
  
  
  
  

Customer_No	Item_No	Unit_Price	Invoice_No	Due_Date
C1101	x11	$275.00	6867	4/2/2021
C1099	co22	$250.00	6868	4/2/2021
C1101	x14	$259.00	6842	3/30/2021
C1099	c200	$189.00	6821	3/26/2021

[v-easonf-msft]

Hi, @Anonymous 

The description is not very detailed.

Can you share a sample pbix and expected result here?

Best Regards,
Community Support Team _ Eason