Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |