Forum Discussion
Solved
Issues to create a data model
Hi , I need some help to solve a problem in my job I need to transform the as is mentioned attached to my to be modeling . To sum up : I need to count how many times each status was Stor...
HI dsplaymaxxis,
You can do unpivoted columns on your fields to convert them to attribute and values.
Unpivot columns (Power Query) (microsoft.com)
Then you can create a matrix with 'product' and 'value' as rows, 'attribute' as the column, 'value' with count mode on the matrix value field to achieve your requirement.
Regards,
Xiaoxin Sheng
this is the problem by print screen
HI dsplaymaxxis,
You can do unpivoted columns on your fields to convert them to attribute and values.
Unpivot columns (Power Query) (microsoft.com)
Then you can create a matrix with 'product' and 'value' as rows, 'attribute' as the column, 'value' with count mode on the matrix value field to achieve your requirement.
Regards,
Xiaoxin Sheng