November 5, 2015 at 3:48 pm
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.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply