Forum Discussion

Jeanxyz's avatar
Jeanxyz
Power Participant
5 years ago
Solved

switch()

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
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    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.

2 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    5 years ago

    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.

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    5 years ago

    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