Trying to forecast future sales based on current year's growth

[Anonymous]

Hi, I have tried several things, and cannot get the data to show up for future dates (returning blank values). Here is my DAX for future forecasting using POWER.

IF(SELECTEDVALUE('Calendar Table'[Year]) > YEAR(TODAY()),

CALCULATE(SUM('Sales'[Total Sales]), FILTER('Calendar Table','Calendar Table'[Year]=YEAR(TODAY()))) *

POWER((1+[Currnt YR YOY%]), 5), "N/A")

Thank you. 

[v-zhangti]

Hi, @Anonymous 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-zhangti thank you for your response. Here's sample data. I am expecting PowerBI to provide expected sales for the next 5 years, however it is showing up blank. 

Data
Year	Total Sales	YoY Change
2018	$40,506	0.00%
2019	$65,559	61.90%
2020	$113,816	73.60%
2021	$238,635	109.70%
2022	$523,221	119.30%
2023	$648,120	23.90%	(Current YR YOY%)
Forecast Results
Year	Measure 6
2018	N/A
2019	N/A
2020	N/A
2021	N/A
2022	N/A
2023	N/A
2024
2025
2026
2027
2028

[Anonymous]

@v-zhangti I should note that the year from my date table is a whole number instead of a date, because it kept putting in "1905" for the date. I suspect that may be part of the problem? But I need the correct year....