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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Sarahhh
Frequent Visitor

Display the last value on the card

Hi everyone,

 

I would like to show the last value/data on my card. I've readen some tutorials, but nothing works.
When I try to put the time column as a filter, nothing changes. I can select the last time data, but the other data doesn't change to the last one.

Can anyone give me any idea how I can solve this? 


Thanks a lot!

1 ACCEPTED SOLUTION

Hey @Greg_Deckler , thanks for the answer!

 

I made a code using the MAX function and it worked pretty well! Here is the code:

 

last =

var last_value = MAX(table_name[column_time_name])

RETURN
MAXX(
FILTER(ALL(table_name),table_name[column_time_name] = last_value),
table_name[column_name]
)


(The "column_name" is the column which you want to see the last data)

 

 

Thanks for the help!

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

@Sarahhh Not entirely certain but you should be able to create a measure using MAX or the default maximum/last aggregation. Again, not 100% on the issue.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Hey @Greg_Deckler , thanks for the answer!

 

I made a code using the MAX function and it worked pretty well! Here is the code:

 

last =

var last_value = MAX(table_name[column_time_name])

RETURN
MAXX(
FILTER(ALL(table_name),table_name[column_time_name] = last_value),
table_name[column_name]
)


(The "column_name" is the column which you want to see the last data)

 

 

Thanks for the help!

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.