Last Sale Date by Sku

[Anonymous]

Hi! I am fairly new to Power BI and need help finding the last sale date of a sku. 

I've tried with the following:

Date = CALCULATE(max(SOP30200_SalesHeader[DOCDATE]),ALLSELECTED(IV00101_ItemMaster[ITEMNMBR]))

but this brings back the last date of sale as yesterday for everything (the last time refreshed).

Can someone point me in the right direction? This will help me for other reports I'm building as well.

Thank you in advance! 

Steph

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Try a measure like

Date = CALCULATE(max(SOP30200_SalesHeader[DOCDATE]),filter(ALLSELECTED(IV00101_ItemMaster),IV00101_ItemMaster[ITEMNMBR] = max(IV00101_ItemMaster[ITEMNMBR])))

[Anonymous]

[Anonymous]

Sales Date is in the header table and item number is in the detail table. 

[amitchandak]

@Anonymous , If the formula i shared not working then; Can you share sample data and sample output in a table format? Or a sample pbix after removing sensitive data.