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 (Flagge...
General Comment
Need Help
Show and Tell
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?