Comments Data.xlsx (13.1 KB)
I am working on Direct Query Mode where I need to show Survey Origin & Survey Responses in One Column and display as Section. Please find attached raw data and desired result.
I am stuck on how to achieve this in DAX and want to get expert’s resolution and views on this scenario.
Please note that Survey Origin is a concatenate field of Region & Country etc.,
Survey Responses are Answers to Open Questions provided.
They are both coming in a single view from Sql Server
Please guide on how best I can solve this with DAX