Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Forecast Figures between dates

I need help with a measure that will return one forecast figure from my forecast table based on budgetforecastfrom and budgetforecastto dates. i filter the forecast figures based on the kpiname. Belo...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    Create a new Table

     

    Table 4 =
SUMMARIZE (
    'Table',
    'Table'[BudgetForecastFrom],
    'Table'[BudgetForecastID],
    'Table'[KPI Name],
    "Period Forecast Date", CALCULATE (
        MAX ( 'Table'[Period Forecast] )
    )
)

     


    Regards,

    Harsh Nathani


    Appreciate with a Kudos!! (Click the Thumbs Up Button)

    Did I answer your question? Mark my post as a solution!

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Create a new Table

 

Table 4 =
SUMMARIZE (
    'Table',
    'Table'[BudgetForecastFrom],
    'Table'[BudgetForecastID],
    'Table'[KPI Name],
    "Period Forecast Date", CALCULATE (
        MAX ( 'Table'[Period Forecast] )
    )
)

 


Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous 

     

    Thank you.