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(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).

Need Help

2 Replies

  • 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