Create 1 column based in the values of two columns in the same table

[BenwillLopez]

Good Morning,

I am trying to create 4 columns (PRSQ5000,PRSQ5001,PRSQ5002, PRSQ5003; from column.question) taking the related value of another column named answer.

This is the expected outcome:

Tried this but did not work: 

Column = IF('KPI_SURVEY (3)'[QUESTION] = "PRSQ500", 'KPI_SURVEY (3)'[ANSWER], BLANK())

EXAMPLE DATA:

QUESTION	ANSWER
PRSQ5000	VERY SATISFIED
PRSQ5001	SOMEWHAT SATISFIED
PRSQ5002	VERY EASY

[v-xiaotang · Accepted solution]

Hi @BenwillLopez 

Thanks for reaching out to us.

>>Column = IF('KPI_SURVEY (3)'[QUESTION] = "PRSQ500", 'KPI_SURVEY (3)'[ANSWER], BLANK())

There is no problem with the grammar, please check if your string is spelled correctly, it seems that there is a 0 missing, 

column PRSQ5000= IF('KPI_SURVEY (3)'[QUESTION] = "PRSQ5000", 'KPI_SURVEY (3)'[ANSWER], BLANK())

column PRSQ5001= IF('KPI_SURVEY (3)'[QUESTION] = "PRSQ5001", 'KPI_SURVEY (3)'[ANSWER], BLANK())

Best Regards,

Community Support Team _Tang

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

[BenwillLopez]

Hello! I apologize for the late reply,

I tested your solution, it does almost answer my question.

Now, how I may be able to "eliminate" the spaces between ?

Can the First or Last calculation be an issue as per the displayed values ?

Screenshot for reference below:

Below expected result: