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 111 times

MattAllington
Posts: 934
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 120 times
Matt Allington is Self Service BI Consultant, Trainer and Author of the book "Supercharge Power BI".
https://exceleratorbi.com.au/power-bi-online-training/


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 3 guests