Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Switch DAX Formula Error

Hi Experts

 

Cannot see what i am doing wrong here with the switch function using a dis connected table....

DAX

 

NoTrend_Significants = 
VAR _Trendmove = SELECTEDVALUE(_TrendDirection[Trends])
Return

SWITCH(TRUE(),

    _Trendmove, "No Trend", [No Trend],
    _Trendmove, "Significant Trend", [Significant Trend],
[PMSComplaintsMN]
)

Error Message

Need Help
  • Ani1991's avatar
    Ani1991
    7 years ago

    Hi Anonymous ,

    You are trying to compare a Boolean object with a text value and hence the datatype mismatch error.

    Can you try modifying the DAX expression as below,

     

    NoTrend_Significants = 
SWITCH(SELECTEDVALUE(_TrendDirection[Trends]),
                "No Trend", [No Trend],
                "Significant Trend", [Significant Trend],
                [PMSComplaintsMN]
)

    Hope this helps!!

     

    Thanks,

    Ani

1 Reply

  • Ani1991's avatar
    Ani1991
    Resolver III
    7 years ago

    Hi Anonymous ,

    You are trying to compare a Boolean object with a text value and hence the datatype mismatch error.

    Can you try modifying the DAX expression as below,

     

    NoTrend_Significants = 
SWITCH(SELECTEDVALUE(_TrendDirection[Trends]),
                "No Trend", [No Trend],
                "Significant Trend", [Significant Trend],
                [PMSComplaintsMN]
)

    Hope this helps!!

     

    Thanks,

    Ani