How can I get the uniqe list off Last occurred for each category?

[MohamadAshuryan]

Hi every one.

I have this list:

products---Prices

product1---1000

product2---2000

product1---900

product3---4000

product2---5000

product3---6000

and I wand to get the uniqe list off Last prices for each products with DAX Like this:

products---Prices

product1---900

product2---5000

product3---6000

[tamerj1]

@MohamadAshuryan 

Can't you add index column using Power Query?

[MohamadAshuryan]

How can I do that?

[tamerj1 · Accepted solution]

Sorry Mohammad,

It was too late last night I didn't see your reply. Here is a sample file with the solution https://we.tl/t-rBJAfyJOu4

Last Price = 
VAR MaxIndex = MAX ( Products[Index] )
RETURN
    CALCULATE ( 
        MAX ( Products[Prices] ),
        Products[Index] = MaxIndex
    )

[MohamadAshuryan]

Thank you very much tamerj1.

[tamerj1]

@MohamadAshuryan 

open the query editor. From the add columns tab select add index column. 

[MohamadAshuryan]

So what shoud I do next?

[tamerj1]

Hi @MohamadAshuryan 

do you have index or date column?

[MohamadAshuryan]

Hi tamerj1,

No, Suppose we have only these two columns.

[tamerj1]

@MohamadAshuryan 

Then the required result is not possible