Re: Help with Table

Syndicate_Admin · ‎08-14-2023

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:

Ejemplo Bi.png

Thank for your help

TomMartens · ‎08-14-2023

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

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Greg_Deckler · ‎08-14-2023

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...