Analyzing PO Performance

Anonymous5  - You could use something like the attached pbix file. There are several steps to consider with this solution:

1. Create a Date table with an M (Power Query) script.
2. Use a lookup table to identify the previous event.
3. In the PO table:
   1. Unpivot the dates - this will allow you to easily compare values within a single measure.
   2. Find the next event date by looking up the previous event, and merging table with itself.
   3. Do the same for "days since create date".
   4. Calculate the number of days between event and previous event, and created date to event.
4. Create a parameters table to allow user to choose between analyzing
   1. Days from creation to event or days since previous event.
   2. Which event's date (for instance, quarter) is being analyzed - create, previous event, or event.
5. Create an Event lookup table, with the purpose of ordering the events.
6. Create relationships between the Date table and PO table, and between the Event table and the PO table.
7. Create measures which take into account the selections from the Parameters table.
8. Create the visualizations

Note: The parameters table could be eliminated and the measures simplified, if only a single type of analysis makes sense.

I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.