Insert different values in a column based on different conditions

[thatjoey20]

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

[Nathaniel_C]

Hi @thatjoey20 ,
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

[amitchandak · Accepted solution]

@thatjoey20 , 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
)

[thatjoey20]

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