Forum Discussion
Counting same values in different columns
Hello everyone! This is my first question here.
My problem is as it follows. I have my data from an excel archive and I have 4 columns that have pre defined values to assign to them. I want to count each of these values from the 4 columns and if possible, to make slicers out of them. I believe that the workaround would be to create a new table having columns for each of these predefined words and making a count for each word in their respective column, but i don't know how.
The only thing each row have in common is the column "Categoria" filled as "Producto". When "CategorÃa" = "Institucional" i would just fill Producto, Producto2, Producto3 and Producto4 as blank or "-". I don't know if this is useful information.
I would like to have a measure to make visuals that counts (based on example in picture): Desodorante: 4, Cabello: 2, Baby: 2, and exclude "-" and blanks (i can just leave blanks instead of "-" as well).
Thank you in advance!
Anonymous
you can try in pq, select first three columns and unpivot other coluns
Unpivot columns (Power Query) (microsoft.com)
Then it will be easier for you to do the calculation
1 Reply
Anonymous
you can try in pq, select first three columns and unpivot other coluns
Unpivot columns (Power Query) (microsoft.com)
Then it will be easier for you to do the calculation