Forum Discussion
Get last element/row for all weeks
Hello guys, I am trying to get the Sales for my products for only the last day within the week. Do you have an idea, how I can solve this? I was thinking about creating a temporary table with ADD...
Anonymous , refer my blog on this
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
Or try like
calculate(lastnonblankvalues(Table[Date], Sum(Table[Unit]) ) )
or
calculate(lastnonblankvalues(Table[Date], Sum(Table[Unit]) ), filter(allselected(Table), Table[Week] = max(Table[Week]) && Table[Product] = Max(Table[Product]) ) )
Thank you so much. It worked with: calculate(lastnonblankvalues(Table[Date], Sum(Table[Unit]) ) )