Forum Discussion

RGG's avatar
RGG
Frequent Visitor
7 years ago
Solved

Monthly Revenue Forecast Between Two Dates

Hi!  I am trying to build a monthly revenue forecast where I have a list of opportunities, the expected monthly value of each opportunity, the expected start date of the project, and the expected end...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi RGG ,

     

    Measure 3 = IF(ISINSCOPE('Table'[OPPORTUNITY]),CALCULATE(SUMX('CALENDAR',[Measure])),SUMX(ALL('Table'[OPPORTUNITY]),CALCULATE(SUMX('CALENDAR',[Measure])))
)

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

You may download my PBI file from here.

Hope this helps.