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

Anything related to PowerPivot and DAX Formuale
sharon.mathew
Posts: 8
Joined: Mon Feb 12, 2018 4:06 am

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

Postby sharon.mathew » Wed Feb 14, 2018 11:48 pm

Hi

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.
Dax findings.xlsx
(20.94 KiB) Downloaded 47 times

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 4 guests

cron