The date column in this data set is in yyyymmdd format.

I am a noob at powerquery and don't even know where to put the query if I wanted to do so.

I tried looking up how to filter for dates, but all I'm seeing is code, and I don't know where to put it to filter for the desired output. I need all dates six months prior, excluding everything before that.

Also, the codes seem super complex.

Again, I'm a noob at powerquery - any help is appreciated.

thanks.

The date column in this data set is in yyyymmdd format.

I am a noob at powerquery and don't even know where to put the query if I wanted to do so.

I tried looking up how to filter for dates, but all I'm seeing is code, and I don't know where to put it to filter for the desired output. I need all dates six months prior, excluding everything before that.

Also, the codes seem super complex.

Again, I'm a noob at powerquery - any help is appreciated.

thanks.

• powerquery

Share Improve this question Follow edited Mar 12 at 22:34 Hilory 2,15777 gold badges1414 silver badges3030 bronze badges asked Mar 12 at 22:00 MICHAELG1117MICHAELG1117 1111 silver badge33 bronze badges 1

• Where is your data set? Is it in Excel spreadsheet? – PM 77-1 Commented Mar 12 at 22:09

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

First step - convert the column to a date type.

Second step - filter...