Find Delta for each row and outreach type over last 8 days

[Coffee2023]

Hello community,

I am looking for help with this DAX equation to find the delta for each row (site/ PI), and for each type of outreach (event, location..ect.) Please see my current equations and screenshot below. It appears correct except it is dulicating everything several times.

Measure *Event = COUNTROWS(FILTER(vw_CommunityOutreachHistoric01,vw_CommunityOutreachHistoric01[COTypeName] = "Event"))

Measure Event delta = Var EV = CALCULATE([*Event],FILTER(vw_CommunityOutreachHistoric01, vw_CommunityOutreachHistoric01[CO Create Date Difference]< 8)) return "(+" & IF(ISBLANK(EV), "0)", EV)

 Thank you for your help in advance! 

[Greg_Deckler]

@Coffee2023 See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395....
The basic pattern is:
Column = 
  VAR __Current = [Value]
  VAR __PreviousDate = MAXX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Date])

  VAR __Previous = MAXX(FILTER('Table',[Date]=__PreviousDate),[Value])
RETURN
 ( __Current - __Previous ) * 1.

Hard to be more specific without sample data, expected output, etc. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Coffee2023]

Hi thank you for your reply.

I am hoping to get the delta for each Outreach type: Event, Location and Referral Provider in the below table By Site Name. Each of the outreach types are calculated using a measure, for example: 

*Event= COUNTROWS(FILTER(vw_CommunityOutreachHistoric01,vw_CommunityOutreachHistoric01[COTypeName] = "Event"))

Now, I need to find the delta for the number of events over the last 8 days in a seperate column.

Thank you! Let me know if I need to elaborate more.

[Greg_Deckler]

@Coffee2023 Sample data as text. Expected output.

[Coffee2023]

I am not sure what you are suggesting. Here is what I am looking for 

[Greg_Deckler]

@Coffee2023 Read this, it is quite clear: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.