Forum Discussion
Remove duplicates rows
Hi romovaro ,
If you want to show the several answers separated you will always get duplicated or triplicated rows, in this case believe that the best option is to have a dimension table for your main data for the form with Id, date and so and then create a fact table with your answers that have duplicates, triplicates and so on.
Then making use of the relational model you can have all your calculations done.
Hi MFelix Thanks for your suggestion. At the end I found a solution in Power Query to split Multiple columns into Rows ALL at once by creating custom columns using the Text.Split formula + creating Table.From Columns and Expand.)
Hi romovaro ,
If you want to show the several answers separated you will always get duplicated or triplicated rows, in this case believe that the best option is to have a dimension table for your main data for the form with Id, date and so and then create a fact table with your answers that have duplicates, triplicates and so on.
Then making use of the relational model you can have all your calculations done.
Hi MFelix Thanks for your suggestion. At the end I found a solution in Power Query to split Multiple columns into Rows ALL at once by creating custom columns using the Text.Split formula + creating Table.From Columns and Expand.)