Create a string from other string in Tabular Model

[yo_peralta23]

Hi,

I´m trying to do a string based in other string.

Original String: "Replacement" with values "Yes" and "No"

Secundary String: "Replacement/New" with values "Repl." (If Replacement string is "Yes") and "New" (If Replacement string is "No")

But in a Tabular Model, the "New Column" option appears deactivated. Im trying to do a New Measure like this:

Replacement/New = SWITCH(TRUE();SUMX(DW_DS_STAFFING_CURRENT;DW_DS_STAFFING_CURRENT[replacement])="Yes";"Replacement";"New")

(I use the SUMX because is the only way I found to Power BI recognize the "Replacement" variable.)

But the result is a Measure, and I cant use to put as column in a table, for instance!

Thats my problem.

Thanks in advance

[v-yuta-msft · Accepted solution]

@yo_peralta23 ,

Are you using live connection mode to connect to the tabular mode? If you are, to create new calculate column, you need to convert live connection mode to import mode.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.