Forum Discussion
PowerrrBrrr
Helper III
4 years agoWhat does this power query does?
I have a report and I am trying to understand the query written in there. This is one of the table which has been manually created and have columns "max" and "min" along with others. I dont understan...
amitchandak
Super User
4 years agoPowerrrBrrr , there is merge (merge queries)happening in second last step and then in last step column Max and min are added to the current table
Merge Tables (Power Query) : https://www.youtube.com/watch?v=zNrmbagO0Oo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=16
PowerrrBrrr
Helper III
4 years agoI dont know what to say to you.. I know that there is merging happening, but as I mentioned in the question, i didnt get how and why the filtering is happening on max columns once for null and then without null and why and how this is getting merged.