Forum Discussion
Solved
Power Query | Get Max Date (2 Columns)
I'd like to capture (maybe in a different column) the max date(Week) under a single month(Month). I think I can manually upadte this kind of data but I am curious though as to how to actually do it v...
One way I could think of is to duplicate your original query, perform Group By transformation by Month with MAX aggregation on Week, then merge join the orginal query with the newly grouped query on Month column
One way I could think of is to duplicate your original query, perform Group By transformation by Month with MAX aggregation on Week, then merge join the orginal query with the newly grouped query on Month column