Create custom column using max and filter

Create one measure

Measure= Calculate(Max(table[Date],all(table)

Then drag id,name,type,measure in table visual and go to visual level filter and set type is fruit.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

Take Min of Type and Max of Fruit in Visual or create a new table like

new table = summarize(table,table[Id],table[Name],"_Type",Min(Type),"_date",Max(Date))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin

Hi,

Actually i gave you incomplete data. My apology.

Data looks like:

ID Name Type Date

100 apple  fruit 01/01/2020

100 apple  sweet 02/02/2020

200  banana fruit 03/03/2020

200 banana sweet 04/04/2020

Expected output

ID Name new_Date

100 apple 02/02/2020

200 banana 04/04/2020

filter: Type=fruit

New_date logic= Max(date) where type=sweet

I tried:

CALCULATE(MAX(Table(date),FILTER(Table,table[type]="sweet"))

but it gave me

ID Name new_Date

100 apple 04/04/2020

200 banana 04/04/2020

I think I need to put GROUPBY but exactly how and where its where i am struggling.

Thanks,

Milan