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 throu...
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
    )

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