topic Create calculated table with unique value from last date in DAX Commands and Tips

Create calculated table with unique value from last date

Anonymous — Tue, 20 Oct 2020 17:08:56 GMT

Hi! I created this example for the problem, i have this table:

and i would like to create a new calculated table with unique "Name" values where "Date" displays the last date and te corresponding value of the column "value", something like this behind: (this is just a example that i made in excel)

i tried SUMMARIZE, but doesn't seems to work, I'm missing something.

Thank you all for your help!!

Re: Create calculated table with unique value from last date

AlB — Tue, 20 Oct 2020 18:22:16 GMT

Hi Anonymous

NewTable = FILTER ( Table1, Table1[Date] = CALCULATE ( MAX ( Table1[Date] ), ALLEXCEPT ( Table1, Table1[Name] ) ) )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers