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
I can't try that now but I see what you want me to do. I think that could be it! I'll let you know how it panned out after I try it.
By the way, SUMMARIZECOLUMNS Function, SUMMARIZE Function and GROUPBY Function could be used in DAX.
