topic Re: How can I get the uniqe list off Last occurred for each category? in DAX Commands and Tips

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

MohamadAshuryan — Tue, 05 Jul 2022 19:21:20 GMT

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

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

tamerj1 — Tue, 05 Jul 2022 19:24:25 GMT

Hi MohamadAshuryan

do you have index or date column?

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

MohamadAshuryan — Tue, 05 Jul 2022 19:27:06 GMT

Hi tamerj1,

No, Suppose we have only these two columns.

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

tamerj1 — Tue, 05 Jul 2022 19:28:20 GMT

MohamadAshuryan

Then the required result is not possible

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

tamerj1 — Tue, 05 Jul 2022 19:29:14 GMT

MohamadAshuryan

Can't you add index column using Power Query?

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

MohamadAshuryan — Tue, 05 Jul 2022 19:31:09 GMT

How can I do that?

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

tamerj1 — Tue, 05 Jul 2022 19:40:36 GMT

MohamadAshuryan

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

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

MohamadAshuryan — Tue, 05 Jul 2022 19:49:16 GMT

So what shoud I do next?

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

tamerj1 — Wed, 06 Jul 2022 03:40:14 GMT

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 )

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

MohamadAshuryan — Fri, 08 Jul 2022 11:20:03 GMT

Thank you very much tamerj1.