Dax formula error Var return If distinctcount

[cristianml]

Hi, 

I need help with the following DAX Fórmula. It gives an error but not sure where is it: 

Forecast Cost =

var Plan = [Forecast Plan Cost]

var Q1 = [Forecast Q1 Cost]

var Q2 = [Forecast Q2 Cost]

var Q3 = [Forecast Q3 Cost]

var Q4 = [Forecast Q4 Cost]

return

IF(DISTINCTCOUNT('Forecast Base'[Base Forecast]) = 1, SWITCH('Forecast Base'[Base Forecast Selected],Plan,Q1,Q2,Q3,Q4),"Select One Forecast for comparisson")

[v-lili6-msft · Accepted solution]

hi, @cristianml 

what is [Forecast Plan Cost]/ [Forecast Q1 Cost]/  [Forecast Q2 Cost]/ [Forecast Q3 Cost]/  [Forecast Q4 Cost]

What is your logic of this formula?

Sample data and expected output would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,
Lin