cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
lfahre Frequent Visitor
Frequent Visitor

Current weekly averages as compared to years past weekly averages

Hello,

 

I am working with a large, police-data set looking at searches.  The data set spans over 5 years, and there are duplicate items (example: if two subjects were apart of one search, they will have the same item number).  I am able to create a measure that counts those individual items, but what I am trying to do is create a line and stacked column chart with the column showing the week-to-date total of searches, and the line showing the average from the weeks from the previous years (example: it is week 6 of 2019, so the column may show 40 searches that have happened thus far, and the line will show the running average of week 6 according to the data from 2014-2018).  I cannot use the individual count measure that I made in this DAX expression.

 

AvgPerWeek = CALCULATE(AVERAGE('Stop and Search'[Week Mon-Sun]),FILTER(ALL('Stop and Search'), 'Stop and Search'[item number this is where I would have liked to use the measure for individual count] =MAX('Stop and Search'[item number this is where I would have liked to use the measure for individual count])))

 

Any help you could give would be awesome.  

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 6 members 3,061 guests
Please welcome our newest community members: