How to calculate conversion rate over last 7 days & conversion rate of prior 7 days

[ERing]

I have a model like below (other columns hidden for confidentiality) and I need to calculate the conversion rate (Total_Inbound_Calls_Booked / Accepted_Calls) for the following:

1. Conversion rate for last 7 days.

2. Conversion for the 7 days prior (days 8 - 14).

3. Change in conversion rate for the last 7 days compared to the prior 7 days (days 8 - 14)

Any and all help is appreciated!

[PijushRoy · Accepted solution]

Hi @ERing 
Can you please try below two measure 

ConversionRate_Last7Days = 
VAR Last7DaysAcceptedCalls = 
    CALCULATE(
        SUM(Inbound_Calls[Accepted_Calls]),
        DATESINPERIOD(Calendar[Date], MAX(Calendar[Date]), -7, DAY))
VAR Last7DaysTotalInboundCalls = 
    CALCULATE(
        SUM(Inbound_Calls[Total_Inbound_Call_Booked]),
        DATESINPERIOD(Calendar[Date], MAX(Calendar[Date]), -7, DAY))
RETURN
    DIVIDE(Last7DaysAcceptedCalls, Last7DaysTotalInboundCalls, 0)

ConversionRate_Prior7Days = 
VAR Prior7DaysAcceptedCalls = 
    CALCULATE(
        SUM(Inbound_Calls[Accepted_Calls]),
        DATESINPERIOD(Calendar[Date], MAX(Calendar[Date]) - 7, -7, DAY))
VAR Prior7DaysTotalInboundCalls = 
    CALCULATE(
        SUM(Inbound_Calls[Total_Inbound_Call_Booked]),
        DATESINPERIOD(Calendar[Date], MAX(Calendar[Date]) - 7, -7, DAY))
VAR ConversionRatePrior = 
    DIVIDE(Prior7DaysAcceptedCalls, Prior7DaysTotalInboundCalls, 0)
RETURN
    ConversionRatePrior

[ERing]

This worked. Thank you!