Forum Discussion
Resolver IIIpercentage using values from two different tables
Resolver IIIlbendlin thank you for the tips. here is a pbix file with sample data: https://drive.google.com/file/d/1_ZphAFTa0eAJgpajmEk4D2jDBLPB7HSm/view?usp=sharing
Super UserWhat does it mean when tickets are entered before the warranty start date?
Why do some projects not have a warranty start date?
I am also looking for the same percentage but only calcuate the last 90 days based on date entered
100% by definition. Unless you mean "last 90 days based on warranty start date"?
- rachaelwalker
The project may consist of several phases. The warranty date is defined at the final phase, marking the date when official completion of the project. Alternatively, it may arise if the project manager deviates from processes. Very frustrating I know. I told them that I will provide the data/metrics, along with an explanation of how it's calculated, so they can assess whether a process change is necessary.
If there is no warranty date, the project is not yet under warranty, and no tickets should be submitted against it. I included the entire dataset in case I need to apply a filter to the formula.
Thank you for asking these questions to better understand the data. I appreciate your help and expertise!
- rachaelwalker
lbendlin forgot to tag