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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Tobias106
Helper I
Helper I

Show in card last value of a date

Hello,

 

my calender goes until 31.12.2024.

 

My last value in column A = 12345 (this is on 16.11.2022). 17.11.2022 and so on is empty.

 

Now I want to show in the card always the value of the last date, with a value. 

 

Any ideas with a measure?

 

Thank you

 

Tobias

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

Hi @Tobias106

 

You can try this measure. Change the table name accordingly. 

Measure = 
var _lastDate = MAXX(FILTER('Table (5)',NOT(ISBLANK('Table (5)'[Value]))),'Table (5)'[Date])
return
MAXX(FILTER('Table (5)','Table (5)'[Date]=_lastDate),'Table (5)'[Value])

vjingzhang_0-1669024542337.png

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

2 REPLIES 2
v-jingzhang
Community Support
Community Support

Hi @Tobias106

 

You can try this measure. Change the table name accordingly. 

Measure = 
var _lastDate = MAXX(FILTER('Table (5)',NOT(ISBLANK('Table (5)'[Value]))),'Table (5)'[Date])
return
MAXX(FILTER('Table (5)','Table (5)'[Date]=_lastDate),'Table (5)'[Value])

vjingzhang_0-1669024542337.png

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

mariussve1
Solution Supplier
Solution Supplier

Hi,

 

Do you have a Date table ( marked as datetable ) in your model? This is recommended and best practice.

 

Then you could use:

 

CALCULATE ( [Measure], LASTDATE( 'Date'[Date] ) )

 

Br

Marius

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors