Forum Discussion
Conditional column evaluation on grouped data to maintain a distinct list
Hello, Using PowerBI I am trying to use Active Directory as the source of user information for our mobile phone accounts because the data in the mobile environment has gotten way out of sync and ...
What you describe makes sense. Maybe have a matrix as a result with four buckets. Active/Inactive and Single/Multiple for x and y axis. Like a magic quadrant chart 🙂
I'm confused by your response.
On one hand, that concept could be helpful for the side project to fix up the gaps in AD data that I know exist, but I am not looking for a visual answer. I am looking for code help to be able to parse through the grouped records to create a 1:1 table of data.
Thanks
I have found through the years that visual solutions are often much easier to achieve than formula based solutions. In other words - I have no idea how your formula could possibly be made to work 🙂 I am sure the experts here will have something that can help you along.