Power Pivot with expiry and not expiry date

[Dico]

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]

Would you care to explain how you determine what goes into failed and not failed?

[Dico]

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.