Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create calculated table with unique value from last date

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 correspond...
Calculatetable
DAX
SUMMARIZE
Table
  • AlB's avatar
    AlB
    5 years ago

    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 

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

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