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

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's avatar
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's avatar
    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.

     

     

    • az38's avatar
      az38
      Community Champion
      6 years ago

      So, Anonymous the solution with summarized table doesnt satisfy you?

      try a measure like

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

      then in visual leave onle month-member of 'total base'[Fecha] hierarchy

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Still not working