Help with Table

[Syndicate_Admin]

I need your help, please, I'm stuck, I have a table with months that are increasing and you have a data value, how can I bring the data value of the last month registered:

Thank for your help

[TomMartens]

Hey,

check if the DAX function LASTNONBLANKVALUE provides what you are looking for: https://dax.guide/lastnonblankvalue/

IF not, provide data that can be easily accessed, meaning not a screenshot. Also, be specific if the "month" column is a text column, or of type data. Do not forget to mention if your data will include more than one year.

Regards,

Tom

[Greg_Deckler]

@Syndicate_Admin You'll want an Index column or a Date column and then you can do a double-lookup: