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
Impactful Individual
Impactful Individual

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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