Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Conditional formatting based on fortnight dates

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...
Need Help
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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