Forum Discussion

icdns's avatar
icdns
Post Patron
6 years ago

CALCULATE WEEKLY RANGE AVERAGE

Hello,

 

Would like to ask for your help in getting and show the "Weekly Average" per assigned manual and assigned fieldman in the line graph: 

For my date range in the X axis, im using this formula': 

DATE_RANGE =
var _mindate =
CALCULATE(
MIN('Date'[FullDateAlternateKey]),
FILTER(
ALL('DATE'),
'Date'[Year]=EARLIER('DATE'[Year])&&
'DATE'[Week of Year]=EARLIER('DATE'[Week of Year])
)
)
var _maxdate =
CALCULATE(
MAX('DATE'[FullDateAlternateKey]),
FILTER(
ALL('DATE'),
'DATE'[Year]=EARLIER('DATE'[Year])&&
'DATE'[Week of Year]=EARLIER('DATE'[Week of Year])
)
)
return
_mindate&" - "&_maxdate

For my Y axis (line graph), im using these measures: 
Contractor_Assigned_MANUAL = CALCULATE(DISTINCTCOUNT(TEAM[NUM]),TEAM[IN_FIELDMAN] = "NO",TEAM[VENDOR_ID] <> "MECOVENDOR")
 
Contractor_Assigned_FIELDMAN = CALCULATE(DISTINCTCOUNT(TEAM[NUM]),TEAM[IN_FIELDMAN] = "YES")
 
Thank you in advance! 

 

Need Help

3 Replies