Group by column, before adding a new conditional column.

[Anonymous]

Hello,

I need some help with adding an coditional column. I want to add the new conditional column (as shown down below) based on a group by on the column fact_data[Casenumber]. Is this even possible? If so, I would like to hear your suggestions!

So in the PowerQuery code, I would like to add something like: "Table.Group("Casenummer"), or do it on another way if that's possible??

= Table.AddColumn(#"Removed Columns", "IncludeOrNot", each if [Max Werkordernummer] <> [Werkordernummer] then "N" else if [Min Werkordernummer] <> [Werkordernummer] then "N" else "Y")

Thanks in advance. 

[Jayaselvan]

Could you please share a sample dataset either in excel or csv? If possible please share the pbi itself.