Switch Formula

[KasRotodyne]

I have been trying to use the Switch Formula in Power BI. Without much luck... Can someone look at it and tell me what I am doing wrong

B_Inkoopbestemming =

Switch(

'T_Inkoop Data& Financieel'[B_RequirementType]=1, "Verkoop",

'T_Inkoop Data& Financieel'[B_RequirementType]=2, "Productie",

'T_Inkoop Data& Financieel'[B_RequirementType]=3, "Voorraad",

'T_Inkoop Data& Financieel'[B_RequirementType]=4, "Kosten",

'T_Inkoop Data& Financieel'[B_RequirementType]=5, "Ongepland"

)

[tamerj1 · Accepted solution]

Hi @KasRotodyne 

please try

B_Inkoopbestemming =
SWITCH (
    TRUE (),
    'T_Inkoop Data& Financieel'[B_RequirementType] = 1, "Verkoop",
    'T_Inkoop Data& Financieel'[B_RequirementType] = 2, "Productie",
    'T_Inkoop Data& Financieel'[B_RequirementType] = 3, "Voorraad",
    'T_Inkoop Data& Financieel'[B_RequirementType] = 4, "Kosten",
    'T_Inkoop Data& Financieel'[B_RequirementType] = 5, "Ongepland"
)

[tamerj1 · Accepted solution]

Hi @KasRotodyne 

please try

B_Inkoopbestemming =
SWITCH (
    TRUE (),
    'T_Inkoop Data& Financieel'[B_RequirementType] = 1, "Verkoop",
    'T_Inkoop Data& Financieel'[B_RequirementType] = 2, "Productie",
    'T_Inkoop Data& Financieel'[B_RequirementType] = 3, "Voorraad",
    'T_Inkoop Data& Financieel'[B_RequirementType] = 4, "Kosten",
    'T_Inkoop Data& Financieel'[B_RequirementType] = 5, "Ongepland"
)

[KasRotodyne]

@tamerj1 

@selimovd 

Thanks for replying, but both formulas return the same error, how do I incorporate the VALUE or FORMAT function?

[tamerj1 · Accepted solution]

@KasRotodyne 

I cannot read this language but I may guess. Please try

B_Inkoopbestemming =
SWITCH (
    TRUE (),
    'T_Inkoop Data& Financieel'[B_RequirementType] = "1", "Verkoop",
    'T_Inkoop Data& Financieel'[B_RequirementType] = "2", "Productie",
    'T_Inkoop Data& Financieel'[B_RequirementType] = "3", "Voorraad",
    'T_Inkoop Data& Financieel'[B_RequirementType] = "4", "Kosten",
    'T_Inkoop Data& Financieel'[B_RequirementType] = "5", "Ongepland"
)

[selimovd]

Hey @KasRotodyne ,

you missed the first argument. This is what you want to compare against the values. In your case the value of the column. 

This approach should work:

B_Inkoopbestemming =
SWITCH (
    'T_Inkoop Data& Financieel'[B_RequirementType],
    1, "Verkoop",
    2, "Productie",
    3, "Voorraad",
    4, "Kosten",
    5, "Ongepland"
)

You could also use a SWITCH with the TRUE as value to compare with. But that usually makes only sense if you want to compare different columns. For example if Country = "France", then return 100, if user = "Kas" then return 200.

The approach with SWITCH and TRUE would be like that, but as I said it wouldn't make sense here:

B_Inkoopbestemming =
SWITCH (
    TRUE (),
    'T_Inkoop Data& Financieel'[B_RequirementType] = 1, "Verkoop",
    'T_Inkoop Data& Financieel'[B_RequirementType] = 2, "Productie",
    'T_Inkoop Data& Financieel'[B_RequirementType] = 3, "Voorraad",
    'T_Inkoop Data& Financieel'[B_RequirementType] = 4, "Kosten",
    'T_Inkoop Data& Financieel'[B_RequirementType] = 5, "Ongepland"
)

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic