Forum Discussion

mmarshalek's avatar
mmarshalek
Frequent Visitor
9 years ago

Calculation of 2 values different dates

I've been working on this for about 5 days now,...  and really stuck...  Could use help...  I've attached my Power BI table..   Trying to subtract "ForecastCore3" from CM_Ship Actuals... Nee...
Need Help
dearwatson's avatar
dearwatson
Continued Contributor
9 years ago

Parallel Period should be your friend here:

 

You need contigeous dates for this to work.. if you dont have running dates use a calendar table :)

 

Forecast Current = SUM(Table1[Forecast])

Forecast -3 = CALCULATE([Forecast Current],PARALLELPERIOD(Table1[Date],-3,MONTH))