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!
I need to sum the quantity of Data Stations Num Bikes Available for each fecha_reporte_API.
The problem is that I have repeated rows (e.g: row 1 and row 2 have the same Data Stations Station Id and so on).
I need to sum ONLY one time for each Data Stations Station Id.
Is there any way to solve this?
Thank you very much!
Solved! Go to Solution.
Please refer, if this can help
https://community.powerbi.com/t5/Desktop/How-to-remove-duplicate-records/td-p/128875
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Please refer, if this can help
https://community.powerbi.com/t5/Desktop/How-to-remove-duplicate-records/td-p/128875
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |