Forum Discussion

wes-shen-poal's avatar
wes-shen-poal
Icon for Helper III rankHelper III
8 years ago
Solved

days between previous date in a column based on condition of another column

Hi there,   I would like to create a new column, called Days_between_visits which calculates the number of days between a date in the ATA (Actual Time of Arrival) column and a previous date also in...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    HI wes-shen-poal

     

    I think this calculated column might be close

     

    New Column = 
VAR LastVisit = MAXX(
            FILTER(
                'Table',
                'Table'[VesselName] = EARLIER('Table'[VesselName]) && 
                'Table'[ATA] < EARLIER('Table'[ATA])),'Table'[ATA])
RETURN IF(LastVisit <> BLANK(),INT('Table'[ATA] - LastVisit))
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

HI wes-shen-poal

 

I think this calculated column might be close

 

New Column = 
VAR LastVisit = MAXX(
            FILTER(
                'Table',
                'Table'[VesselName] = EARLIER('Table'[VesselName]) && 
                'Table'[ATA] < EARLIER('Table'[ATA])),'Table'[ATA])
RETURN IF(LastVisit <> BLANK(),INT('Table'[ATA] - LastVisit))
wes-shen-poal's avatar
wes-shen-poal
Icon for Helper III rankHelper III
8 years ago

Hi Phil_Seamark

 

This is perfect. Thank you so much for your help.

 

Wes