DAX function to create LY Measure without date dimension

Question

Is there a DAX Function I can use for my issue? To get LY I have to subtract 10 from HalfYear. There´s no date dimension. It should show Net value among HalfYear dimension e.g. 20121 (Year+HalfYear 1 or 2). How do I create such a measure? 

Thanks in advance!

Answer 1

It should be fairly simple (sumx of lookup to old year value). DAX-wise it goes like:

DEFINE MEASURE Table[LY]=SUMX(
  Table,
  LOOKUPVALUE(Table[NetSales], Table[HalfYear], Table[HalfYear] - 100)
)
EVALUATE ADDCOLUMNS(Table, "LY", Table[LY])