Virtual table with multiple columns with multiple DAX formulas

Hi yall

Im having a big issue with this and was wondering if someone of you had the same issue before;

So I have 3 tables:

The first one is:  idEquipments

The second one is: idProjects

third is the mix of the above for example:

first table:

idEquipment    Status

1                       Ok

2                       Repair

3                       Damaged

4                       Ok

Second table:

idProject          lifeTime

1                      90

2                      80

3                      90

Third:

idEquip         date                  status        idProject

1                    10/18/2022      Ok              1

2                    10/18/2022      Damage     3

3                    10/18/2022      Stock          1

4                    10/19/2022      Damage     3

2                    10/20/2022      Ok              2

3                    10/20/2022      Ok              2

So what im trying to achieve is to have a table where I can see which equipment is in what status and how much time does it took to get damaged filtered by every project, so the result will look like this

idEquip       Status                timeOnSelectedProject       projectLifeTime      Criteria

1                  Damaged           10                                      15                            Bad

2                   Ok                     10                                      7                            OK

3                   OK                     5                                        10                          OK7

if anyone have an idea on how to do this, i will really apreciate it

thanks in advance!