Creating a Measure to identify the last date greater than 90 days

Anything related to PowerPivot and DAX Formuale
Meathead
Posts: 1
Joined: Fri Oct 21, 2016 1:23 am

Creating a Measure to identify the last date greater than 90 days

Postby Meathead » Fri Oct 21, 2016 2:11 am

Good Day,

I'm looking for help to write a Measure that identifies the last date of an item that occured greater than 90 days of today()'s date. I want the PowerPivot to show only those item numbers that fall within this criteria. Please note the I have a filter on the PowerPivot that identifies a specific transaction.

I've attached sample data for your review.

I'm using MS Excel 2016.

Thank you for any help.

Sample Data.xlsx
(10.54 KiB) Downloaded 28 times

MattAllington
Posts: 816
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Creating a Measure to identify the last date greater than 90 days

Postby MattAllington » Fri Oct 21, 2016 5:19 pm

How about this



see the attachment
Sample Data.xlsx
(107.7 KiB) Downloaded 30 times
Matt Allington is Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 1 guest