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