Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @ricamore
Open Edit queries, "Ctrl" +click on {"Person","Month","Year","Number Available"} columns,
then select Home->Remove Rows->remove duplicates.
Best Regards
Maggie
Community 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.
Hi @ricamore
Open Edit queries, "Ctrl" +click on {"Person","Month","Year","Number Available"} columns,
then select Home->Remove Rows->remove duplicates.
Best Regards
Maggie
Community 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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |