Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have in my data duplicated names but with different account numbers. But when i aggregate on name because the account number doesn't make sense to see in the report it obviously aggregates at the name level, how can i aggregate the data at the correct level, is there a way of using the key (account number) with out actually displaying the key? There is a one to one mapping between account and name, but sometimes there are more than account with the same name, but they are different accounts. So when you aggregate on name it ignores that its a different account.
i was thinking maybe sort by column would work but it doesn't
Proud to be a Super User!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |