Measure to show next years forecast based on year slected from slicer

[Anonymous]

Hi Experts

See attached pbix file link. I am trying to work out next years forecast value  when the slicer year is previous yr. So when slicer selected is 2020, matrix table to show forecast for 2021.

When 2019 is selected forecast to show 2020.

Pots to note in my model the relationship between bridge and calendar is both and bridge and forecast is 1 to *.

The year slicer comes from calendar table.

Link: https://www.dropbox.com/s/tks6aal2uy5omd2/show_next_year_forecast_based_on_slicer.pbix?dl=0

[CNENFRNL · Accepted solution]

Hi, @Anonymous , as the granularity of forecast is month, the granularity of slicer can be also set to month accordingly. I attached the pbix file for your reference.