Forum Discussion

ruthgammack's avatar
ruthgammack
Frequent Visitor
4 years ago
Solved

switch statement using text and a number column

Trying the below when the kms are 0 it still will return a 0 and not 20. Is there a way i can use the below with some minor changes??
 
Buffer Kms = SWITCH(TRUE(),
('Co-ordinate'[Mode] = "Air") , 'Co-ordinate'[Kms]/100*22,
('Co-ordinate'[Mode] = "Sea") ,'Co-ordinate'[Kms]/100*24,
('Co-ordinate'[Mode] = "Roa"), 'Co-ordinate'[Kms]/100*18,
('Co-ordinate'[Mode] = "Rai"), 'Co-ordinate'[Kms]/100*9,
('Co-ordinate'[Mode] = "Cou"), 'Co-ordinate'[Kms]/100*22,
('Co-ordinate'[Kms] = 0), 20, 0
)
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi ruthgammack 

    Try this:

    Buffer Kms =
IF (
    'Co-ordinate'[Kms] = 0,
    20,
    SWITCH (
        TRUE (),
        ( 'Co-ordinate'[Mode] = "Air" ),
            'Co-ordinate'[Kms] / 100 * 22,
        ( 'Co-ordinate'[Mode] = "Sea" ),
            'Co-ordinate'[Kms] / 100 * 24,
        ( 'Co-ordinate'[Mode] = "Roa" ),
            'Co-ordinate'[Kms] / 100 * 18,
        ( 'Co-ordinate'[Mode] = "Rai" ),
            'Co-ordinate'[Kms] / 100 * 9,
        ( 'Co-ordinate'[Mode] = "Cou" ),
            'Co-ordinate'[Kms] / 100 * 22
    )
)

     

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

    Appreciate your Kudos✌️!!

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    The last condition must be the first. It really does matter what you put where in switch.

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    Hi ruthgammack 

    Try this:

    Buffer Kms =
IF (
    'Co-ordinate'[Kms] = 0,
    20,
    SWITCH (
        TRUE (),
        ( 'Co-ordinate'[Mode] = "Air" ),
            'Co-ordinate'[Kms] / 100 * 22,
        ( 'Co-ordinate'[Mode] = "Sea" ),
            'Co-ordinate'[Kms] / 100 * 24,
        ( 'Co-ordinate'[Mode] = "Roa" ),
            'Co-ordinate'[Kms] / 100 * 18,
        ( 'Co-ordinate'[Mode] = "Rai" ),
            'Co-ordinate'[Kms] / 100 * 9,
        ( 'Co-ordinate'[Mode] = "Cou" ),
            'Co-ordinate'[Kms] / 100 * 22
    )
)

     

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

    Appreciate your Kudos✌️!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I have refering url column under which urls listed like below

    google.com
    facebook.com

    instagram.com
    linkedin.com

    i want ad need column which lists respective urls

     

    how can i do