Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Adding a Projection to Historical Data

Hello, I am looking to take historical QOH data & be able to add on a calculated future projection to a model. I've added a picture of a small example I created. I know the logic needed, but ca...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-lionel-msft

amitchandak 

I have included the formulas to my measures below, and here is a link to the .pbix file .

 

Historical QOH (Measure) = 
    SUM('zz - Practice QOH'[Historical QOH])

Demand (Measure) = 
    SUM('zz - Practice QOH'[Demand])

POs Landing (Measure) = 
    SUM('zz - Practice QOH'[POs Landing])

Forecast = 
    [Demand (Measure)] + [POs Landing (Measure)]

QOH + Forecast = 
    CALCULATE('zz - Practice QOH'[Historical QOH (Measure)],LASTDATE('zz - Practice QOH'[Date]) ) + [Forecast]