Power Pivot with expiry and not expiry date

Dico

Member
Joined
May 23, 2020
Messages
41
Reaction score
0
Points
6
Excel Version(s)
2019 Pro Plus
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 and here
 

Attachments

  • Sample Pivot Table.xlsx
    228.3 KB · Views: 9
Would you care to explain how you determine what goes into failed and not failed?
 
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,
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.
 
Last edited:
Back
Top