Forum Discussion
Calculating inventory by week?
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
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.
3 Replies
dccuong ,
calculate(lastnonblankvalues(Table[Date], Sum(Table[Weight])), filter(allselected(Date), Date[Week] = max(date[Week]() )))
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.
Great, thanks a lot
