Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
sonya7
Helper III
Helper III

How to get the value at the latest date, where values are not 0?

‎07-27-2022 12:56 PM

hello, I want to show the last entered value instead of zero values. I was able to find the total number as far as I tried. how can i get the last value?

 
 
 
 
Labels:
Message 1 of 22
1,728 Views
0
1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User
In response to sonya7

‎08-04-2022 03:54 AM

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Message 16 of 22
1,522 Views
0
21 REPLIES 21
lbendlin
Super User
Super User

‎07-28-2022 03:21 PM

Don't use MAX in a filter inside CALCULATE.  Use variables outside of CALCULATE.  You are also missing the ">0"  filter.

Message 2 of 22
454 Views
0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

View All