Calculating inventory by week?

[dccuong]

Hi All
I want calculating inventory by week, only take the weekly number of the weekend with data, take the Sunday, if Sunday does not have the number, take it back to the 7th day...

Please help me write Dax

Thank you

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

https://1drv.ms/u/s!AiUZ0Ws7G26RiiC1pQGTlq1q7it1?e=OfcgLE

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

[dccuong]

Great, thanks a lot

[amitchandak]

@dccuong ,

calculate(lastnonblankvalues(Table[Date], Sum(Table[Weight])), filter(allselected(Date), Date[Week] = max(date[Week]() )))