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...
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

try create a new table

NewTable = summarize(Table;Table[Data].[Month];"lastinventory";LASTNONBLANK(Table[Inventario];1))

or

NewTable = summarize(Table;Table[Data].[MonthNo];"lastinventory";LASTNONBLANK(Table[Inventario];1))

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi az38 ,

Thank you for your response, however, i didn't find the expected result.

Table = SUMMARIZE('total base','total base'[Fecha].[Month],"lastinv",LASTNONBLANK('total base'[Inventario],1))
The right one is the result of the table:
For example In January i just need 143947 as result.
Thank you again.