Conditional formatting based on fortnight dates

[Anonymous]

hi,

Below is my model .My "appointment" table has details like when appointment is scheduled(column schedulestart) while in "activity parties" i have account names for which appointment is scheduled(column Account name).they have 1-many relation based on account id(appointments) and partyid(activity parties)

I  am showing data in a table as below.My requirement is to highlight Account name and start time columns if a meeting is happening for a same account in next 15 days(fortnight).

[v-chuncz-msft]

@Anonymous 

Add a calculated column and take advantage of Apply conditional table formatting.

Column =
VAR a = 'Table'[Account]
VAR t = 'Table'[start time]
RETURN
    IF (
        ISEMPTY (
            FILTER (
                'Table',
                'Table'[Account] = a
                    && DATEDIFF ( t, 'Table'[start time], DAY ) > 0
                    && DATEDIFF ( t, 'Table'[start time], DAY ) < 15
            )
        ),
        0,
        1
    )

[Anonymous]

hey @v-chuncz-msft thanks for you reply ..It should also return 1 for  date 2/4/2020.. as its within 15 days for same account