Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Extract last data from a month

Hello everyone, I have this table and i just want to extract the last inventory of each month, i've been trying without succesfull results. I'd really appreciate some help:   The expected re...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Still not working

 

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

add .[Month]

Measure = 
calculate(lastnonblank('total base'[Inventario],1), allexcept('total base','total base'[Fecha].[Month]))

looks like this

do not hesitate to give a kudo to useful posts and mark solutions as solution