Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello!
I am having an issue with a dataset of survey outputs where each question of the survey is a different row of data. There is a column titled "Survey Invitation ID" that identifies each unique survey. I would like to create a column that can take the response to one particular question (always the same question, 5 possible response values) and fill the column with those responses as they correlate to each specific survey ID (i.e. if customer fills out Survey ID 1 and indicates that they work at a university, the new column with results would identify each row from Survey ID 1 as being a university customer). I tried using the formula
Hi, @mhennes1
The screenshot you shared shows incomplete information. I can’t see some columns in your code, nor can I see the relationship between Survey Invitation ID and other columns in the table.
But I think you problem is not hard to solve if you can upload some insensitive data samples and expected output.
Best Regards,
Community Support Team _ Janey
WARNING!!! Salesforce is case sensitive, DAX is not!!! You must use Case Safe IDs!!!
(yes, I know, lots of exclamation marks. But this is important.)
User | Count |
---|---|
88 | |
88 | |
74 | |
67 | |
58 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |