Forum Discussion

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...

Icon for Community Champion rank

Community 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
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.
- az38
  Community Champion
  6 years ago
  Hi Anonymous
  for january result is correct as I see
  the right table says that you have a data from other monthes.
  if you want to see onle january try
  Table = SUMMARIZE(FILTER('total base', MONTH('total_base'[[Fecha]])=1),'total base'[Fecha].[Month],"lastinv",LASTNONBLANK('total base'[Inventario],1))
  do not hesitate to give a kudo to useful posts and mark solutions as solution
  - Anonymous
    Not applicable
    6 years ago
    az38
    I have a data base with weekly sales and inventory. I can accumulate the sales during the year, but the inventory is the current state of stock in each week ( so the inventory of the month is the inventory of the last week of the month with data ).
    I need a measure ( i suppose), that gives me the last week of inventory when i use each month in a visualization.
    
    Thank you.

Related content