Forum Discussion
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...
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
)
amitchandak
Super User
Super UserAnonymous , 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
)
It worked!! Thank you very much! Just needed to put true as a expression condition !