Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Insert different values in a column based on different conditions

Hello guys, 


I am struggling trying to define this DAX statement, 

basically I have a table where there are ID_SELLER, NAME SELLER, MONTH NUM and I want to insert GOAL VALUE differently through the months for each seller 

So for instance if ID_SELLER == 300 && MONTH NUM == 1, GOAL VALUE = 120000
                                                    ''           MONTH  NUM == 2, GOAL VALUE = 130000
                                                    later on
                                                    301       MONTH NUM  == 1....           VALUE = 50000
                                                                                                2

I tried using SWITCH(IF(ID_SELLER == 300 && MONTH NUM == 1, TRUE()), TRUE(), 120000) 


but didn't know how to continue inserting other months since DAX doesnt let me set values in variable conditions. I believe this would result in a many lines statement, does anyone have a simillar solution or can help with something? 

Thank you very much

Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Create a new column like

     

    GOAL VALUE = Switch( True(),
    [ID_SELLER] = 300 && [MONTH NUM] = 1, 120000,
    [ID_SELLER] = 300 && [MONTH NUM] = 2,130000
    //add others
    )

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Create a new column like

     

    GOAL VALUE = Switch( True(),
    [ID_SELLER] = 300 && [MONTH NUM] = 1, 120000,
    [ID_SELLER] = 300 && [MONTH NUM] = 2,130000
    //add others
    )

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      It worked!! Thank you very much! Just needed to put true as a expression condition ! 

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    5 years ago

    Hi Anonymous ,
    Try this measure

    GOAL TO REACH =
IF (
    Goals[Seller ID] = 300
        && Goals[Month #] = 1,
    12000,
    IF (
        Goals[Seller ID] = 300
            && Goals[Month #] = 2,
        13000,
        IF ( Goals[Seller ID] = 301 && Goals[Month #] = 1, 50000 )
    )
)

     




    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel