Forum Discussion
Extract last data from a month
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.
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
Still not working
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
Hi, az38 and thank you for your time and patience.
Your last solution should have worked, but it has not. I don't know if there is a problem with the way that power bi sum the inventories in each week.
inv final mes = calculate(lastnonblank('total base'[Inventario],1), allexcept('total base','total base'[Fecha].[Month]))