Hi,
I'm new to the forum buit have been an avid user in the past 8 months learning M and Dax very quickly thanks to all the information provided in the forum. I've now hit a roadblock and hoping for some ideas how to progress.
Background:
I've time series data for available stock which projects what my stock is going to be at the start of every week for every SKU (product).
Objective:
I'm trying to build a pivot table to display for each SKU what my stock will be over the next 52 weeks (easy part). So my Hierarchy is SKU and then Week number. The subtotal on the top level (SKU) however, needs to display the available stock in the current week (first line of each SKU) as opposed to the sum of the next 52 weeks.
If required I can attach the sample data, but in reality there will be much deeper levels of drill down, and I'm just trying to understand the concepts and formulas used at this point. Thanks in advance.
Alex
