Create column that shows data difference compared with last week in date format (YYYYWK)

Hi, Anonymous 

Please try formula like:

diff =
VAR _previousweek =
    CALCULATE (
        MAX ( 'Table'[Week] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Week] < MAX ( 'Table'[Week] ) )
    )
VAR _previousvalue =
    CALCULATE (
        [Stock weeks(FC)],
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Week] = _previousweek )
    )
RETURN
    [Stock weeks(FC)] - _previousvalue

'Table'[Week] (YYYYWK) need to be adjusted to 'whole number' type.

Best Regards,
Community Support Team _ Eason

Hi Sammy,

Please try this measure and see if it works.

TonyZhou1980 
Ive done some tweaking and following code seems to work to branch down into one sub-category:

Diff. StockWk (FC) =
  var _previousweek =
  calculate(
      max('Power BI'[Week]),
      filter(allselected('Power BI'), 'Power BI'[Week]<max('Power BI'[Week]))
)
  var _previousWEEKqty =
  calculate(
      [Stock weeks (FC)],
      filter(allselected('Power BI'), 'Power BI'[Week] =_previousweek)
)
var _previousPRODqty =
  calculate(
      [Stock weeks (FC)],
      filter(allselected('Power BI'), 'Power BI'[Week]=_previousweek),
      values('Power BI'[Product type])
)
return
  SWITCH(
      TRUE(),
      ISINSCOPE('Power BI'[Product type]),[Stock weeks (FC)]-_previousPRODqty,

      ISINSCOPE('Power BI'[Week]),[Stock weeks (FC)]-_previousWEEKqty,
      blank()
)

I cannot seem to figure out how to add more subcategories to this. Because in reality I would want to branch down further 2-3 subcategories.

Any help is appreciated
/Sammy

Hey,

I have managed now. Many thanks all for the help. If anyone is interested, here is the code I used with help from TonyZhou1980. Just replace SUB-C with your own sub categories: