Forum Discussion
Power Query help to extract unique values
So in this case, I am working with a roster list that changes weekly. I have posted a screenshot that shows a small example of what i am dealing with. We're talking literally 1000's of agents that I ...
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RhjELX0063Mh6apM9?e=cP00ai
So maybe I'm doing this wrong. This is actually within Excel and using their Power Query. Maybe I shouldn't have posted this here, but since it is here, maybe you or someone else can still help.
I get this error when I try to follow your steps in Excel.