Forum Discussion

KasRotodyne's avatar
KasRotodyne
Frequent Visitor
4 years ago
Solved

Switch Formula

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"
)
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    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's avatar
    tamerj1
    4 years ago

    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"
)

4 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    4 years ago

    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
     

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    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's avatar
      KasRotodyne
      Frequent Visitor
      4 years ago

      tamerj1 

      selimovd 

       

       

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

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

        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"
)