Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
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 . :))
User | Count |
---|---|
98 | |
90 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |