IF 4 [Fields] =EARLIER[Fields] Then Return DATEDIFF( Curr Date - Previous Date) Days - need help

[sharonmathew]

Hi my usual life saving Folks,

i have uploaded a link here which i request help.

the First sheet is Data sheet, and second is results.

i am seeking help to get, the measure which would do,

the below.

IF AIRLINE = EARLIER[AIRLINE]
&& FLIGHTNO = EALIER[FLIGHTNO]
&& DEPARTURE = EARLIER[DEPARTURE]
&& DESTINATION = EARLIER[DESTINATION]
THEN

RETURN

DATEDIFF between (CURRENT DATE, ie. ROW date - PREVIOUS DATE)

thanks.

data file link
http://powerpivotforum.com.au/viewtopic.php?f=6&t=1057

[Greg_Deckler]

EARLIER is typically used in a calculated column context. I think to use it in a measure, you would need to do some kind of SUMMARIZE.

[sharonmathew]

yes, summary is, 

from the table,

                              if all the 4 fields match

                              then

                              we need to find the difference between the dates.

Note 1 , other than the 4 fields, there are some more fields which need not be matched.

Note 2, the date difference should be calculated only after table is filtered with 4 field criteria.

the date difference is between the current date and its previous occurance.

i hope i explained . :))