Forum Discussion

andytmcc's avatar
andytmcc
Icon for Helper I rankHelper I
3 years ago
Solved

Add a Filter to a Switch

I have created a column that assigns a value (0, 0.5 or 1) based on the difference between 2 other columns:   locusofcontrol = SWITCH( TRUE(), 'Loneliness All Data'[Locus Of Control Mean] > ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi,

     

    Try like this

     

    test_switch = switch(
    True(),
    and('Table'[Product]=1,'Table'[Serial Number]=99),1,
    and('Table'[Product]=1,'Table'[Serial Number]<>99),2,0)
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi,

 

Try like this

 

test_switch = switch(
True(),
and('Table'[Product]=1,'Table'[Serial Number]=99),1,
and('Table'[Product]=1,'Table'[Serial Number]<>99),2,0)