Forecast Figures between dates

[Selded]

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

[harshnathani · Accepted solution]

Hi @Selded ,

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!

[Selded]

@harshnathani 

Thank you.