Please help with SUMMARIZE and removing extra line

[uniqque2008]

I am using a SUMMARIZE to aggregate the data and create a table with a unique list of Vehicles assigned to a Plant.

However, i am getting 2 lines for same Fleet number, where Plant changed within the same month.

I am struggling to remove one of the lines based on the Max Availability column, which is the number of minutes allocated to a Plant during the month (this example Date field = Month).

Result i am loking for is retaining the SECOND (617760) line and removing First (12690 mins) 

Please help, as i am getting nowhere fast.

[uniqque2008]

Yes i understand that. I need Maintenance Plant. Is there any way to kepp Plant and also do what I need?

[v-yuta-msft · Accepted solution]

@uniqque2008 ，

As a general suggestion, you can firstly achieve the opposite table using SUMMARIZE() function, then use EXCEPT() function to achieve the result table.

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.

[rocky09]

can you share some sample data?

[rocky09]

You will get Two lines unless you remove Maintenance Plant.