Max of date from the column

[Anonymous]

I have created data and  Ticket number in my column as below

Created Date	Ticket Number
March 19, 2022	INC1627413
March 18, 2022	INC1627413
March 17, 2022	INC1627413
March 16, 2022	INC1627413
March 15, 2022	INC1637653
March 15, 2022	INC1637653
March 14, 2022	INC1637653
March 14, 2022	INC1637653
March 13, 2022	INC1637659
March 13, 2022	INC1637659

i have to create nem column which has the maximum data for each ticket in all the rows examle as below

March 19, 2022 is the max date for INC1627413
March 15, 2022 is the max date for  INC1637653

Created Date	Ticket Number	Max Date
March 19, 2022	INC1627413	March 19, 2022
March 18, 2022	INC1627413	March 19, 2022
March 17, 2022	INC1627413	March 19, 2022
March 16, 2022	INC1627413	March 19, 2022
March 15, 2022	INC1637653	March 15, 2022
March 15, 2022	INC1637653	March 15, 2022
March 14, 2022	INC1637653	March 15, 2022
March 14, 2022	INC1637653	March 15, 2022
March 13, 2022	INC1637659	March 13, 2022
March 13, 2022	INC1637659	March 13, 2022

[v-rongtiep-msft · Accepted solution]

Hi @Anonymous ,

Please refer to my pbix file to see if it helps you.

Create a column.

max_ = CALCULATE(MAX('Table'[ Created Date]),FILTER('Table','Table'[Ticket Number]=EARLIER('Table'[Ticket Number])))

If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.

Best Regards

Community Support Team _ Polly

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

[Tahreem24]

@Anonymous Try this:

Measure  = CALCULATE(MAX(TicketTable[Created Date]),ALLEXCEPT(TicketTable,TicketTable[Ticket Number]))

[mh2587]

Max_date = DATEVALUE(MAX('Table'[DATE]))