Keep rows only when the date is equal to the end of month

[ARag]

Hi, 

I have a dataset with dates for each day of a given period. I'm trying to filter and only keep rows where the event date = the last date of the given month. 

How do I perform that in PowerQuery (Doing it in DAX after data is loaded is not an option)? 

[mussaenda]

Hi @ARag ,

do you have an end date column?

[watkinnc · Accepted solution]

You can use the GUI function in the columns tab, under Date, to add and End of the Month column, then use 

Table.SelectRows(PriorStep, each [Date] = [EndOfMonth])

--Nate