Hi,
I created a measure in Power Pivot model to calculate max date within category. How can I calculate second max date for category?Please Login or Register to view this content.
Hi,
I created a measure in Power Pivot model to calculate max date within category. How can I calculate second max date for category?Please Login or Register to view this content.
Not too familiar with PP, but take a look and see if LARGE() will do what you want?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi,
Replace FirstLargest with the name of your measure for calculating the max.PHP Code:
SecondLargest :=
CALCULATE (
MAX ( 'Invoices'[Date] ),
FILTER (
ALLEXCEPT ( 'Invoices', 'Invoices'[Category] ),
Invoices[Date] <> [FirstLargest]
)
)
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks