Find value from the last 8 days, based on measure and date difference calculations

[Coffee2023]

Hi, I need to find the Events Delta (Delta Column in picture below) from the last 8 days, based on my measure calculation created for # of Events and Create Date Difference expression, which calculates the difference in days between my create date and today.

Example of wanted outcome: 

# of Events = COUNTROWS(FILTER(vw_table,vw_table[COTypeName] = "Event"))

Create Date Difference = DATEDIFF('vw_table'[CreateCODate], TODAY(), DAY)

Current Errored Delta Forumla: 

Delta = CALCULATE(SUMX('vw_table, 'vw_table[# of Events], FILTER('vw_table,'vw_table[Create Date Difference] < 8)))

Thank you in advance for your help!

[Anonymous · Accepted solution]

Hi @Coffee2023 ,

Thanks for the reply from @AmiraBedh , please allow me to provide another insight: 

According to your description, I added a few rows of data.

You can create calculated columns.

Column = 
CALCULATE (
    COUNT ( 'Table'[Site Name] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[Outreach TypeName] = "Event"
            && 'Table'[Site Name] = EARLIER ( 'Table'[Site Name] )
            && 'Table'[Outreach Create Date].[Date]
                <= EARLIER ( 'Table'[Outreach Create Date].[Date] )
            && 'Table'[Outreach Create Date].[Date]
                > EARLIER ( 'Table'[Outreach Create Date].[Date] ) - 8
    )
)

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AmiraBedh]

Can you share yopur initial data ?

[Coffee2023]

Here are some examples

[AmiraBedh]

Can you formulate an understable dataset in text and not image ? help us to help you ?

[Coffee2023]

Site Name	PI	Outreach TypeName	Outreach Create Date
IACT Health	Paull	Event	7/10/2019 11:43
Center of Reproductive Medicine	Schnell	Event	7/9/2019 23:50
Center for Cognitive Health	Mega	Event	7/9/2019 15:42
Center for Cognitive Health	Mega	Event	7/9/2019 15:34
Baumann Cosmetic & Research Institute	Baumann	Event	7/7/2019 21:37
Baumann Cosmetic & Research Institute	Baumann	Event	7/7/2019 21:35
Baumann Cosmetic & Research Institute	Baumann	Event	7/7/2019 21:33
Baumann Cosmetic & Research Institute	Baumann	Event	7/7/2019 21:13
Baumann Cosmetic & Research Institute	Baumann	Event	7/7/2019 21:07
Center of Reproductive Medicine	Schnell	Event	7/5/2019 23:54
Center for Cognitive Health	Mega	Event	7/5/2019 12:18
Meridien Research - St. Petersburg	Lefebvre	Event	7/3/2019 13:30
Meridien Research - St. Petersburg	Lefebvre	Event	7/3/2019 13:26
Baumann Cosmetic & Research Institute	Baumann	Event	7/1/2019 22:52
Baumann Cosmetic & Research Institute	Baumann	Event	7/1/2019 22:51

Let me know if this is helpful. Thank you!