I am having trouble in creating a specific logic. The ideia is find the average of the diference of the days between specific rows.
For example: IDDateCriteria
In this example, I want to know the date difference between criteria but in the same ID. The formula is = DateDifference ID = Second - First In excel that would be: ID 1 = 03/02/2018-18/01/2018 = 16 days ID 2 = 14/03/2018-25/01/2018 = 48 days ID 3 = Blank (there is no second criteria) ID 4 = Blank (there is no second criteria) So, the average of that is 32.
Just like the table under:
DateDIFF (Second - First)
I want to do the same for (Third-Second), and so on...
How Can I create a Measure of that?
Thanks ikn advance, I am stuck in this problem for a few days now....