Forum Discussion
Create a list from Values and count them by date.
Hello everyone.
I couldnt find any solution in the forum, waste whole day to find it( but i have ni luck (or brain).
There is my Table:
I need to create a list from all phone models and count all of them.
Should be somethis like this:
I created anothe table with all phone names and create relationship, but active releationship was only with 1 column and only this 1 cloumn was counting right... but others no (
Please help me to find solution... ( looks like iam very bad in Power BI (((
Please copy and paste data examples as tables not a screen shots (then we can import the data and build an example solution).
You need to unpivot the phone columns into one column called Phones
Remove all other columnsRemove blanks.
Drag Phones to a table visual
Drag Phones to a table visual and select count
Voila. You have the report !
Thanks for reaching out for help.
I have helped you, now please help me by giving kudos.
Remeber we are unpaid volunteers.
Click the thumbs up and accept as solution button.
One question per ticket please. If you need to extend your request then please raise a new ticket.
You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !
1 Reply
speedrampsSuper User
Please copy and paste data examples as tables not a screen shots (then we can import the data and build an example solution).
You need to unpivot the phone columns into one column called Phones
Remove all other columnsRemove blanks.
Drag Phones to a table visual
Drag Phones to a table visual and select count
Voila. You have the report !
Thanks for reaching out for help.
I have helped you, now please help me by giving kudos.
Remeber we are unpaid volunteers.
Click the thumbs up and accept as solution button.
One question per ticket please. If you need to extend your request then please raise a new ticket.
You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !