How To Remove Duplicate Rows In Power Query Based On Conditions

In this video, you will see how to clean up transactional data in Power Query, including a hack to generate M code for multiple nested table transformations by just using the User Interface and a method for creating a Running Total in Power Query.

*****Video Details*****
0:34 three scenarios formulated
1:44 adding column with absolute quantities
2:10 group by ID index and absolute quantity
2:30 add a new column - sum of the quantity
2:47 add aggregation - AllRows
3:27 add custom column for nested table transformations
4:22 build transformation - add new query
4:38 sort on movement type
4:57 sort posting date
5:15 List.FirstN function
6:15 add index column
6:34 custom column - running total
8:24 add filter condition
8:32 remove helper columns
8:47 advanced editor
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/

Видео How To Remove Duplicate Rows In Power Query Based On Conditions канала Enterprise DNA