Forum Discussion
Bring Value for Max Date by Key in Power Query
Take a look at this gif:
The most complicated part is the merge stage. You have to merge with the table itself, but in the ChangeType step. To choose more than one column to link the two tables, you have to use ctrl + left click in the same order in both tables, as I did in the gif.
Hi _AAndrade do you have the PBIX or screen capture from steps "GroupByMaxDate" and "Merge"? Because I have a spanish installation of Power BI and I'm struggling finding the same buttons you used to build the solution. Thank you!!!
Take a look at this gif:
The most complicated part is the merge stage. You have to merge with the table itself, but in the ChangeType step. To choose more than one column to link the two tables, you have to use ctrl + left click in the same order in both tables, as I did in the gif.