M query to find do group by and remove min of year data row

[subhashree_r]

Hey people,

   given below is the screenshot of my data set 

I want to eliminate The rows that are minimun year corresponding to the store in m query. Can anyone guide me through the problem guys 

[v-yuta-msft · Accepted solution]

@subhashree_r ,

Duplicate the table, group the min year by store in the duplicated table:

 

Then merge the original table and duplicated table based on store and year column using left anti join, remove the useless columns and you will achieve the result:

 

You can also refer to the pbix file.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.