Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Last purchase value

Hello tod@s, I have the following scenario and problem, with the following two measures: Measure Last Purchase Date: Fecha_Ultima_Compra = LASTNONBLANK(Calendar[Date],[Valor_Precio_Unit_Final]) ...
rubayatyasmin's avatar
rubayatyasmin
Icon for Community Champion rankCommunity Champion
3 years ago

Hi, Syndicate_Admin 

 

you need to modify the measures to consider both the item and the month context when calculating the last purchase date and amount.