Forum Discussion

SurferJames's avatar
SurferJames
Frequent Visitor
2 years ago

Conditional Formatting BI

I am fairly new to BI.

 

I have a table that has the following contents:

 

- Orginated time (This is when the call hit)

- Orginator (Customer number)

- Customer

- Age

- Any Disability (Flagged as 'Y' or 'N)

 

I need to create the following conditional formatting

 

- Any customer that has called more than ten times in a single month = red 

- Any customer that has called us more than 5 times in 7 days = yellow/amber

- Any customer that is over 65 and called us more than 5 times in 7 days = red

 

I haven't created any measures or date tables to reference single month or 7 days along with measures to create the conditional formatting.

 

Any help will be greatly appreciated.

 

Thanks,

 

James

General Comment
Need Help
Show and Tell

2 Replies

  • JoeBarry's avatar
    JoeBarry
    Solution Sage
    2 years ago

    Hi SurferJames 

     

    I'm trying to undestand the 7 days part, is it the last 7 days or is it any 7 day period in a month? 

     

     

    • SurferJames's avatar
      SurferJames
      Frequent Visitor
      2 years ago

      I have created two measures like this:

      1.

       

      Last 30 Days = VAR startdate = TODAY() - 30
      return
      CALCULATE(COUNT('Contact Log'[Originator]),'Contact Log'[Originated Time]>= startdate)
       
      2. 

       

      Last 7 Days = VAR startdate = TODAY() - 7
      return
      CALCULATE(COUNT('Contact Log'[Originator]),'Contact Log'[Originated Time]>= startdate)
       
      Now I want to conditional format it but I can't seem to use two measures, how would I combine them with the rules I want in the original message?