Forum Discussion
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 Stored in the table above .
Count how many times the channel URA received the status "available" , "NO Info" , etc.
If the status was not part of that channel , so I would like to place the value 0 in the Tobe table .
How do I create that in DAX ou power query?
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
2 Replies
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
