Maximum value with nested if ciondition

[#1]

Hi

I have a table

Table

Swipe in time     employee       get in time

11-12-2015        john                21-07-2015

    null( -)            john                17-12-2015

14-11-2015        john                14-11-2015

i want a condition in the script that if my Swipe in time is greater than get in time i want to use the get in time

if my Swipe in time has null value then i want to use the get in time else i want  to use Swipe in time

my out put is

swipe in time

21-07-2015

17-12-2015

14-11-2015

[sunny_talwar]

May be this:

Table:

LOAD [Swipe in time],

  If(Len(Trim([Swipe in time])) = 0 or [get in time] > [Swipe in time], [get in time], [Swipe in time]) as [New Swipe in time],

  employee,

  [get in time];

LOAD * Inline [

Swipe in time,     employee,       get in time

11-12-2015,        john,         21-07-2015

   ,        john,         17-12-2015

14-11-2015,        john,         14-11-2015

];

[maxgro]

maybe

load

     ...,

     Date(rangemin([Swipe in time], [get in time])) as NewField,

.....