Forum Discussion
New column adjusting for duplicates?
Hi all,
I'm trying to consololidate some data. Basically for "number available", when I import, POWER BI autofills the sums based on person, month and year and brings it down for the other empty columns. The problem is Power bi autofills the number available and I want them to be removed. I want the formula to be contingent on person, month, year, and removes same item to bring 1. here is an example:
| Person | Month | Year | Number Available | Desired Colunn |
| 1 | Jan | 2019 | 3 | 3 |
| 1 | Jan | 2019 | 3 | |
| 1 | Jan | 2019 | 3 | |
| 1 | Jan | 2018 | 4 | 4 |
| 2 | Jan | 2019 | 2 | 2 |
| 2 | Jan | 2019 | 2 | |
| 2 | Jan | 2018 | 3 | 3 |
| 2 | Jan | 2018 | 3 | |
| 3 | Jan | 2018 | 5 | 5 |
| 3 | Feb | 2018 | 4 | 4 |
| 3 | Mar | 2018 | 6 | 6 |
| 3 | Apr | 2018 | 7 | 7 |
| 3 | Jan | 2019 | 8 | 8 |
| 3 | Jan | 2019 | 8 | |
| 3 | Jan | 2019 | 8 |
thank you so much, new to forum. Let me know if yuu need more details
Hi ricamore
Open Edit queries, "Ctrl" +click on {"Person","Month","Year","Number Available"} columns,
then select Home->Remove Rows->remove duplicates.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi ricamore
Open Edit queries, "Ctrl" +click on {"Person","Month","Year","Number Available"} columns,
then select Home->Remove Rows->remove duplicates.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.