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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Lotfi96
Regular Visitor

Using a filter to get the last date

Hello,

 

I'd like to ask a question about a measure I've been making recently, I'm trying to get the last value from the amount column based on a date, the columns look like this:

 

Lotfi96_0-1695906459687.png

 

I used the following measure:

 

Measure = CALCULATE(SUM(Database[Amount]), Database[date]=LASTDATE(Database[date]))
 
However I get an error saying that I can't use the LASTDATE function in a true/false expression. Is there another way around to get the latest date? I tried using the max function "Database[date]="Max(Database[date])", but it returned nothing.
 
Any help would be apreciated. 
1 ACCEPTED SOLUTION

I found the solution to the problem, I had to look for it, but it was really simple. There was already a function called " ENDOFMONTH" that I was unaware of. I'll pin this message as a solution in case someone needs it in the future.

View solution in original post

3 REPLIES 3
chonchar
Helper V
Helper V

Hello, 

 

I am new here, but try this:

 

MEASURE Sales[Sales last day] =
        CALCULATE (
            [Sales Amount],
            LASTDATE ( 'Date'[Date]
 
Also, if this works, please accept it as a solution. 

Hello, thank you for your answer, however this doesn't work.

I found the solution to the problem, I had to look for it, but it was really simple. There was already a function called " ENDOFMONTH" that I was unaware of. I'll pin this message as a solution in case someone needs it in the future.

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.

Top Solution Authors