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& Financiee...
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"
)
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"
)