Forum Discussion

evalromf's avatar
evalromf
Icon for Helper I rankHelper I
10 years ago

AND IF in conditional column

Hi,   I'm trying to create a new column that should be populated with a certain number based on the contents of several other columns.   What I'm looking for is something like this:   If [COUNT...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
8 years ago
Hi there

When you say create a DAX measure, what is the expected result from your data you posted?
RodrigoTXRA's avatar
RodrigoTXRA
Icon for Helper I rankHelper I
8 years ago

Hello again

It think that it would be something like this formula below, but the other way around, instead of transforming numbers into text, for the month, it would transform text into numbers.

 

=SWITCH([Month], 1, "January", 2, "February", 3, "March", 4, "April" , 5, "May", 6, "June", 7, "July", 8, "August" , 9, "September", 10, "October", 11, "November", 12, "December" , "Unknown month number" )

 

Any ideas?

Regards

Rodrigo