Forum Discussion
Solved
In Power Query last day in Month
I need to filter a column of dates that from a file that has Daily amounts. I need to filter out all but the last day of the month for each month and the last available date. So for January = 1/31...
Select your Date column, then go to
Add Column > Date > Month > End of Month
Give it a try and let us know