cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
corbusier Regular Visitor
Regular Visitor

Filter out most recent date in visual?

I have a few visuals where I am using a date Axis and a bunch of measures. I would like to filter out the most recent date, however I'm not sure how to do it.

 

I have tried this measure but it just returns the second-most recent date.

 

CALCULATE(data[week_date],FILTER(data,data[week_date]<>MAX(data[week_date])))

Any help would be appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
corbusier Regular Visitor
Regular Visitor

Solution found

The solution was simpler than I thought.

Column = IF(data[week_date]<MAX(data[week_date]),data[week_date],BLANK())
2 REPLIES 2
corbusier Regular Visitor
Regular Visitor

Re: Filter out most recent date in visual?

I also saw this post, which deals with a similar problem but I would like my solution to be applicable to multiple measures at once.

 

https://community.powerbi.com/t5/Desktop/Last-month-data-filter-in-DAX/m-p/210850#M93071

corbusier Regular Visitor
Regular Visitor

Solution found

The solution was simpler than I thought.

Column = IF(data[week_date]<MAX(data[week_date]),data[week_date],BLANK())

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 296 members 3,073 guests