Extraer el ultimo valos de una tabla

[CESGUT]

Saludos,

Tengo una Tabla con fecha y valores numerico, y necesito extraer el valor numerico de una tabla a la ultima fecha, es decir, necesito extraer el dato remarcado en azul a l aultima fecha reportada.

Saludos

[v-piga-msft]

Hi @CESGUT ,

I'm not familar with your language, here is my translation via Google tranlate.

Spoiler

I have a Table with date and numeric values, and I need to extract the numerical value from a table to the last date, that is, I need to extract the data highlighted in blue at the last reported date.

If I undersand your requirement correctly that you want to get the value in the third column for the last date?

If so, you could create the measure with the formula below.

value of last date = CALCULATE(MAX('Table1'[Column3]),FILTER('Table1','Table1'[Date]=MAX('Table1'[Date])))

Here is the output.

Best  Regards,

Cherry

[CESGUT]

Hi Cherry,

I tried your formula but didnt work, find below the error....

[v-piga-msft · Accepted solution]

Hi @CESGUT ,

Based on your image, it seems that you missed a ")" after Max function.

In addition, please check if you created it as a  measure.

For reference, you could use this tool to check if you have syntax error for dax expression.

Best Regards,

Cherry

[CESGUT]

Hi Cherry,

Thanks for your response.

Yes, that is exactly what I am looking for. The last value at the last date.