PDA

View Full Version : Power Pivot with expiry and not expiry date



Dico
2020-08-14, 12:53 PM
Hi,

I try to get a Pivot Table in Power Pivot according to the result given in the attached file
Can you please help me?
All solutions are welcome : Power query, Pivot Table or DAX

Thank you in advance

Crossposting here (https://www.excelguru.ca/forums/showthread.php?10755-Pivot-Table-modification) and here (https://chandoo.org/forum/threads/power-pivot-with-expiry-date.44839/)

Bob Phillips
2020-08-19, 05:06 PM
Would you care to explain how you determine what goes into failed and not failed?

Dico
2020-08-19, 11:29 PM
Would you care to explain how you determine what goes into failed and not failed?

Hi Bob Phillips

Thank you for your interest,

To answer your question, I had 2 solutions here (https://chandoo.org/forum/threads/power-pivot-with-expiry-and-not-expiry-date.44839/),
I'm sorry, I should have said it here.

I don't know if it's useful to continue this thread knowing that my problem has been solved.

Thanks anyway.

Have a nice day.