Forum Discussion
percentage using values from two different tables
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
lbendlin thank you for the tips. here is a pbix file with sample data: https://drive.google.com/file/d/1_ZphAFTa0eAJgpajmEk4D2jDBLPB7HSm/view?usp=sharing
What 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 entered100% by definition. Unless you mean "last 90 days based on warranty start date"?
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!
