Forum Discussion
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
Community Champion
Community ChampionAnonymous
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]))