How to combine responses in multiple table fields into one field

[aneuk22]

Hi All,

I have tried my best to do read posts watch Power BI training videos in how to my requirements but no luck so far, but I am pretty new with Power BI and a bit is going over my head.

So I have a Customer Feedback form which capture multiple values of responses. So currently users will need to choose 2 of the following options.

Using Direct Import to PowerBI Desktop using sql query to return the following result.

So I would like to achieve the following with a idea of new column created in PowerBI called Feedbacks which combine all responses of each users in one field. I just want to find out if it is possible to achieve something like this in Power BI. 

Any help would be greatly appreciated. Thank you

[Nathaniel_C]

Hi @aneuk22 ,

Glad this worked for you!

Nathaniel

[Nathaniel_C · Accepted solution]

Hi @aneuk22 

Try This

UserFeedback = 

var _FE = Max('Table'[FeeExpensive])
var _FB = MAX('Table'[FoundBetterProduct])
var _NM = MAX('Table'[NotMuchContent])

var _Switch = Switch (TRUE(), AND(And(_FE = 1, _FB = 1),_NM=0), "FeeExpensive, FoundBetterProduct",
                       AND(AND( _FB = 1 , _NM = 1),_FE=0), "FoundBetterProduct, NotMuchContent",
                       AND(AND( _FE = 1 , _NM  =1),_FB=0),"FeeExpensive,NotMuchContent",
                        "FeeExpensive,NotMuchContent,FoundBetterProduct")

Return _Switch

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

[Ashish_Mathur]

Hi,

Do you want to achieve this result in the visual or in the raw table itself?  Please also share the raw data in a format that can be pasted in an MS Excel file.