SSAS Tabular 2014 Beginning of Period Measures

• Phillip Trumpy

  Grasshopper

  Points: 11

  More actions

  November 5, 2015 at 3:48 pm

  #306299

  I am a new user of SSAS that has had no training as of yet. I've managed to cobble together one model, but I'm having trouble with my second. What I would like to do is use calculation from one period as the starting point for the next period. I thought I stumbled on something with the DAX Earlier() function, but I haven't had any luck yet. My data looks like this:

  Period 1 Period2

  BegBackOrd BegOnHand ProjectedDemand ProjectedReceipts ProjectedDemand ProjectedReceipts

  10 0 10 12 6 10

  I need to perform calculations and then use those numbers as the BegBackOrd number for the next period.

  Calculation would be BegOH+ProjectedReceipts-BegBackOrd-Demand, so 0+12-10-10 = -8. I then need to show 8 as the BegBackOrd for Period2.

  I only have the BegBackOrd and BegOnHand for Period 1.

  I have searched for some examples to follow, but I'm afraid I'm not even sure what to look for. Can someone please help? I apologize, but I can't figure out how to make my numbers appear under the headers.