cancel
Showing results for
Search instead for
Did you mean:
Highlighted
Member

## Take max of date by column

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

1 ACCEPTED SOLUTION

Accepted Solutions
Established Member

## Re: Take max of date by column

@leharkapil

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])```

3 REPLIES 3
Established Member

## Re: Take max of date by column

@leharkapil

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])```

Member

## Re: Take max of date by column

Hi,

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

Community Support Team

## Re: Take max of date by column

You may check post below.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.