Take max of date by column

[Anonymous]

Hi,

I have a dataset attached below : 

Dealer	Date	Maturity	Output Date	Output Maturity
H1000	2018-01-01	Low	2018-01-04	High
H1000	2018-01-02	Medium	2018-01-04	High
H1000	2018-01-03	High	2018-01-04	High
H1000	2018-01-04	High	2018-01-04	High
N0500	2018-03-06	Low	2018-03-08	Medium
N0500	2018-03-07	Low	2018-03-08	Medium
N0500	2018-03-08	Medium	2018-03-08	Medium

I want to calculate max date for each dealer name and

the output should have a single maturity and single date for each dealer.

Output column is attached.

Please help

[ryan_mayu · Accepted solution]

@Anonymous

Please try the below coding to see if this can meet your requirements.Thanks.

Column = MAXX(FILTER(Sheet33,Sheet33[dealer]=EARLIER(Sheet33[dealer])),'Sheet33'[DATE])

Column 2 = 
VAR MAXDATE = MAXX(FILTER(Sheet33,Sheet33[dealer]=EARLIER(Sheet33[dealer])),'Sheet33'[DATE])
RETURN MAXX(FILTER('Sheet33',Sheet33[dealer]=EARLIER(Sheet33[dealer])&&'Sheet33'[DATE]=MAXDATE),Sheet33[Maturity])

[Anonymous]

Hi,

Im new to power bi, could you please explain how does earlier operate. The documentation is confusing

[v-chuncz-msft]

@Anonymous,

You may check post below.

https://community.powerbi.com/t5/Desktop/This-Function/m-p/326489#M145679