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