Forum Discussion
Helper IFind latest entry with power query editor
Hard to tell what you are doing wrong. Even from the UI, the column names don't change for the simple example of two columns -- one with the dealno and one with the date. When you enter the name of your max date column, it can be whatever you want (even the same as the original date column).
If you are expanding a subtable, you may have to edit that step in the Advanced Editor to get rid of the "renaming" which the UI generated step wants to do. That is merely a matter of deleting the optional newcolumnnames argument.
Helper IThe reason I dont want to set up a group-by is all the Visuals are completed. When ever I set up a Group-by the column names all change and I have to start over building visuals etc.?
Or maybe I am doing somthing wrong?
Super UserHard to tell what you are doing wrong. Even from the UI, the column names don't change for the simple example of two columns -- one with the dealno and one with the date. When you enter the name of your max date column, it can be whatever you want (even the same as the original date column).
If you are expanding a subtable, you may have to edit that step in the Advanced Editor to get rid of the "renaming" which the UI generated step wants to do. That is merely a matter of deleting the optional newcolumnnames argument.
- nrowey
I did not reliize I could rename to exsisting column names.. This worked Thanks so much...