Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Create calculated table with unique value from last date

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

1.PNG

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)

2.PNG

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

 

Thank you all for your help!!

 

 

1 ACCEPTED SOLUTION
AlB
Super User
Super User

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 

SU18_powerbi_badge

 

View solution in original post

1 REPLY 1
AlB
Super User
Super User

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 

SU18_powerbi_badge

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Kudoed Authors