Show next years forecast based on slicer selection

[Anonymous]

Hi Experts 

My years slicer comes from Dim_Date Table the Dim_Date table links to Forecast Table via  a Bridge period as the forecast tabke is based on 12 months forecast. (Months Dim_Date links to Months Forecast Table)

Scenario.

I want to select say year 2020 from.slicer and show in a matrix table forecast for 2021, likewise of i select 2019 I want to show 2020 forecast and so on..

[v-yingjl · Accepted solution]

Hi @Anonymous ,

Based on your description, I have created this sample table:

Create this measure:

Next year forecast =
IF (
    ISFILTERED ( 'Calendar'[Date].[Year] ),
    CALCULATE (
        SUM ( 'Table'[Sales] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Date].[Year]
                = SELECTEDVALUE ( 'Calendar'[Date].[Year] ) + 1
        )
    ),
    "Please select a year to forecast"
)

Attached a sample file in the below, hopes to help you.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous ,You can use year ahead measure 

example

Year ahead Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],1,Year))

next year

Next year Sales = CALCULATE(SUM(Sales[Sales Amount]),nextyear('Date'[Date]))

Next  YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],1,Year),"12/31"))