Filter by first file of month

[Amardeep100115]

Hi

please guide

i have attached BI file in which i shared data in that there 4-5 data file from each month. 

i wish to be filter first file of that month to be filtered in query editor, also please note i have tried grouping for this as well

you may also refer my same query on community Click Here  

Excel Data 

[Anonymous]

CALCULATE(
    FIRSTDATE(data[File Date]),
    ALLEXCEPT('data',data[Month])
)

[Amardeep100115]

Thanks
But I wish to be have in query editor i wish to have table like as shown in the shared excel file

[Anonymous]

Please insert the following code in the last position of power query:

= Table.AddColumn(#"Changed Type", "firstDate", each Table.SelectRows(#"Changed Type", 
(n) => n[Month]=_[Month] and n[Year]=_[Year]
){0}[File Date])

[Amardeep100115 · Accepted solution]

No Worries Super User!

Got my answer by using grouping again 

 but Thanks Again

[Amardeep100115]

Thank you and Sorry,

By grouping i got the result like the excel pivot table

now i wish to filter that data by first file of the month in query editor.

Sample Data