Forum Discussion
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]) ...
@Syndicate_Admin , I hope you are well,
I'm sorry it doesn't work for me, given the following:
- I use a table called Calendar: "Calendar = CALENDAR(MIN(Compras_Detallada[f_fecha]), MAX(Compras_Detallada[f_fecha]))".
- I have a relationship between two Tables: Compras_Detallada [f_fecha] & Calendar [Date].
- To segment or filter dates I use the calendar table, in this case the segmenter is Calendar [Month].
I attach my . Pbix