topic switch statement using text and a number column in DAX Commands and Tips

switch statement using text and a number column

ruthgammack — Wed, 15 Sep 2021 12:47:08 GMT

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

)

Re: switch statement using text and a number column

Anonymous — Wed, 15 Sep 2021 14:38:40 GMT

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

Re: switch statement using text and a number column

VahidDM — Thu, 16 Sep 2021 11:00:23 GMT

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✌️!!

Re: switch statement using text and a number column

ruthgammack — Tue, 21 Sep 2021 12:31:24 GMT

unfortunately it doesnt work. ill keep trying

Re: switch statement using text and a number column

Anonymous — Tue, 17 Jan 2023 06:38:11 GMT

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