Forum Discussion

lava_'s avatar
lava_
Icon for Helper I rankHelper I
3 years ago
Solved

How to return value based on max date within a group

I created a table of three columns that are pulling from another table. I want this created table to ultimately be grouped by ID_1, and pull in the value from ID_2 column based on the group's max Clo...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi lava_ ,

     

    Please try:

     

    Table = FILTER('DealsTable',[ClosingDate]=CALCULATE(MAX('DealsTable'[ClosingDate]),FILTER('DealsTable',[ID_1]=EARLIER(DealsTable[ID_1]))))

     

    Final output:

    Best Regards,

    Jianbo Li

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

v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi lava_ ,

 

Please try:

 

Table = FILTER('DealsTable',[ClosingDate]=CALCULATE(MAX('DealsTable'[ClosingDate]),FILTER('DealsTable',[ID_1]=EARLIER(DealsTable[ID_1]))))

 

Final output:

Best Regards,

Jianbo Li

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

lava_'s avatar
lava_
Icon for Helper I rankHelper I
3 years ago

This worked! Thank you so much.