switch()

[Jeanxyz]

I'm trying to write a switch function with multiple conditions in the <value> part (selectedvalue(Fact_Forecast[Version])="LE02" && maxdate>=date([CurrentYear],5,1)), it looks this won't work in a Switch() function. How can I solve the problem without using embedded if function?

Forecast Amount_Mgmt PL View (EUR) YTD_2 =

var maxdate=max(dim_date[Date])

var amt=Switch(true(),

selectedvalue(Fact_Forecast[Version]) in {"LE00","LE01"},[Forecast Amount_Mgmt PL View (EUR)],

selectedvalue(Fact_Forecast[Version])="LE02" && maxdate>=date([CurrentYear],5,1)

calculate([Reporting Amount_Mgmt PL View],datesbetween(Dim_Date[Date],date([CurrentYear],1,1),date([CurrentYear],4,30))) +calculate([Forecast Amount_Mgmt PL View (EUR)],datesbetween(Dim_Date[Date],date([CurrentYear],5,1),maxdate)

)),

selectedvalue(Fact_Forecast[Version])="LE03",

calculate([Reporting Amount_Mgmt PL View],datesbetween(dim_date[Date],date([CurrentYear],1,1), date([CurrentYear],7,31))) + calculate([Forecast Amount_Mgmt PL View (EUR)],datesbetween(Dim_Date[Date],date([CurrentYear],8,1),date([CurrentYear],12,31)

)))

Return

amt

[v-xiaotang]

Hi @Jeanxyz 

Have you solved your problem? If yes, kindly accept the answer helpful as the solution. so the others can find it more quickly.

Or

if problem still persists, please let me know.

Best Regards,

Community Support Team _ Tang

[v-xiaotang · Accepted solution]

Hi @Jeanxyz 

I‘ve create a sample and the measure with similar logic works OK.

if problem sitll persists, could you share your PBI file after removing sensitive information?

Best Regards,

Community Support Team _ Tang

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