Forum Discussion
Post PartisanGroup by first initial and Quantity 0
How can I get the below output?
First I want to extract only first Letter from the location.
Then in the output, show in the desired format as first initial, locations with that initial and selecting only those locations from Table 1 where Quantity is 0
ryan_mayu Anonymous Anonymous
Hey learner03 ,
go into Power Query, select the column and chose:
Tabl "Add column" --> "Extract" --> "First Characters"
Like this you get your "First Initial" column. The rest is then only reporting what shouldn't be a problem with the data you have then.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
4 Replies
- selimovd
Most Valuable Professional
Hey learner03 ,
go into Power Query, select the column and chose:
Tabl "Add column" --> "Extract" --> "First Characters"
Like this you get your "First Initial" column. The rest is then only reporting what shouldn't be a problem with the data you have then.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic 
learner03Thanks, Why am I getting below view in matrix and not like yours as first character and location in different column-
