How to extract max value within group of product (with measure)

[gwaczoka23]

Hi,

can someone please help write a measure which could help me achieve the result from the last column?
I'd like to have only one value for each group of products (for product A I want only 500 in one row)

I have a lot more (less needed here) columns in this table, which expected measure should not take into account

Product	salesdate	avg price	avg price2
A	01.01.2022	500	500
A	02.01.2022	500
A	03.01.2022	500
A	04.01.2022	500
A	05.01.2022	500
A	06.01.2022	500
B	01.01.2022	888	888
B	02.01.2022	888
B	03.01.2022	888
B	04.01.2022	888
B	05.01.2022	888
B	06.01.2022	888

[v-yadongf-msft · Accepted solution]

Hi @gwaczoka23 ,

Please create a measure:

Measure = 
MAXX (
    'Table',
    IF (
        'Table'[salesdate]
            = MINX (
                FILTER (
                    ALL ( 'Table' ),
                    'Table'[Product] = SELECTEDVALUE ( 'Table'[Product] )
                ),
                'Table'[salesdate]
            ),
        'Table'[avg price]
    )
)

The result you want:

Remember to select "show items with no data":

Best regards,

Yadong Fang

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