top of page

Remaining Forecast / Allocation

Writer: Imran Haq
Imran Haq
Sep 27, 2021
1 min read

Actual & Forecast =
VAR _LatestDate =
CALCULATE(MAX(Dates[LatestMTD]), REMOVEFILTERS())
VAR _Forecast =
CALCULATE([Measure Forecast], KEEPFILTERS(Dates[Date] >= _LatestDate ))
VAR _Actuals = [Measure YTD]
VAR Result = _Actuals + _Forecast
RETURN
     Result




 
 
 

Recent Posts

See All

Comments


Post: Blog2_Post
bottom of page