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. Below is a snip of how my forecast table looks like.  i have added a snip of my expected results .

 

Forecast Table

 

 

Expected results.

 

Thanks for the help

  • 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!

     

2 Replies

  • 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.