Forum Discussion
Create matric with data from same column
I have this dataset with multiple questions and answers:
The above shows only data from 2 question, but there are 18 different questions.
Is it possible in any way, using the ...
Hi Bokazoit
To achieve this, you may need to duplicate the tables and filter the questions to Blue questions and Red Questions.
Create a Dimension table with the SurveyID as a distinct value. You should also have Date table.
Load the tables into Desktop and create a relationship with the Dimension table to both tables on the Survey ID column and the Date table on the Date column (Date table should be marked as date table) https://learn.microsoft.com/en-us/power-bi/guidance/model-date-tables
Create a measure
Amount = sum(BlueQuestions[Amount]) + sum(RedQuestions[Amount])
In the Matrix, add the Blue Question in the Row section and the Red Question in the column section then add the Amount measure
Hmmm, I think I tried that, but will give it a try again. Return with the result if succes or failure 🙂