Forum Discussion
LASTNONBLANK
Hi there !! I am wanting to add a column to my table and in this column I want to obtain the value that it gives me in the last date filtered with id. I have an id column, a value column, a d...
You can try this column expression, replacing Table with your actual table name.
Ultimo Valor = CALCULATE(LASTNONBLANKVALUE(Table[fecha], MAX(Table[valor])), ALLEXCEPT(Table, Table[id))
Pat
if you are satisfied with a solution in power query and upload an example table that is copyable, II can try to search for what you ask