Swapping tables in SWITCH DAX

Hi msksenthil 

What exactly are you trying to do?  I don't understand how/why you are testing values and what to return.

It doesn't look like your SWITCH statements are correct.

The syntax is 

SWITCH
( 

VALUE_TO_TEST,

CONDITION_1, VALUE_TO_RETURN,

CONDITION_2, VALUE_TO_RETURN,

....

DEFAULT_VALUE_TO_RETURN
)

So you might typically use it like this

SWITCH
(
TRUE,

_var < 5 , "Less than 5",

_var < 10 , "Less than 10",

.....

"Greater than 100"
)

Regards

Phil

PhilipTreacy 

I trying to swap the TABLES (multiple values like column) instead of value (single value) bases on the TRUE() condition

Hi msksenthil 

But the first parameter in your SWITCH isn't TRUE so how's it doing any comparison?  How are you intending to compare tables?  What is in these tables?

Can you share your file please.

Regards

Phil

Hi msksenthil 

OK, well, SWITCH can only return scalar values, not tables.  Perhaps you can rewrite your code so that the measure returns a value that indicates which table to use?

Regards

Phil