CALCULATE WEEKLY RANGE AVERAGE

[icdns]

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! 

[amitchandak]

@icdns , Not very clear. Can you share sample data and sample output in table format?

See if this can help

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...

https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3

[icdns]

Hello,

For example, i have data, I have a matrix table where in it displays the total fieldman assigned in Manual and fieldman for that week range. 

So in my line graph, I wanted to show the average fieldman per assigned manual and assigned fieldman in my line graph per WEEK RANGE. 

This is my line graph: 

X axis shows my week range and Y axis shows the percentage. 

The points are the average. 

Thank you. 

[v-shex-msft]

HI @icdns,

Please share some dummy data that similar to your raw table structure to help us clarify your data structure and test coding formula on your sample data. It is hard to direct coding formula on visualization records.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng