Forum Discussion

KatieH's avatar
KatieH
Advocate IV
9 years ago
Solved

Daily Targets

Hi all, hoping to get some help and guidance around adding target info to my Dashboard.   I have report that shows all calls made by a Department in the Company (Call Department). This data is the...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    KatieH,

     

    It's not very hard to create such a table. I have tested it on my local environemnt, the steps below are for you reference.

     

    1. Create a employee table.
    2. Create a date table.
      Date = CALENDAR(DATE(2017,9,1),DATE(2017,9,30))
    3. Cross join those two tables.
      Table = CROSSJOIN('Date',Employee)
    4. Create two column in new table.
      Target = IF(WEEKDAY('Table'[Date])>=2&&WEEKDAY('Table'[Date])<=6,25,0)
      MaxValue = IF(WEEKDAY('Table'[Date])>=2&&WEEKDAY('Table'[Date])<=6,40,0)

     

    Regards,

    Charlie Liao

     

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

KatieH,

 

It's not very hard to create such a table. I have tested it on my local environemnt, the steps below are for you reference.

 

  1. Create a employee table.
  2. Create a date table.
    Date = CALENDAR(DATE(2017,9,1),DATE(2017,9,30))
  3. Cross join those two tables.
    Table = CROSSJOIN('Date',Employee)
  4. Create two column in new table.
    Target = IF(WEEKDAY('Table'[Date])>=2&&WEEKDAY('Table'[Date])<=6,25,0)
    MaxValue = IF(WEEKDAY('Table'[Date])>=2&&WEEKDAY('Table'[Date])<=6,40,0)

 

Regards,

Charlie Liao