Creating a measure that counts where a created date is between the date parameters

[reh169]

I have a lot of quote data. Those quotes have customers and those customers have dates that they were created. I want to be able to count the number of quotes that were created in the time period selected by the parameters, when and only when the customer that is tied that quote has a created date that falls in the range of the parameters. For example:

If I have 5 quotes each have a different customer for the month of October 2019. Of those 5, 3 of them have customers that were created in the month of October. How do I capture that metric?

[smpa01]

@reh169can you provide some sample data and demonstrate the desired result with the logic to apply to arrive there please

[reh169]

@smpa01 So see the data below. I have the customer created date below, and I want to be able to count the number of quotes where the customer created date falls into the range of my date parameters. I am using the job start year and job start month as my date parameters as chiclets. I am not just not sure how the logic works out in dax. 

[smpa01]

@reh169  can you give the source data in an excel table format

[reh169]

I found this and tried it but it is not working, did I do something wrong?

=
CALCULATE (
    DISTINCTCOUNT ( Data[Name] ),
    CALCULATETABLE ( VALUES ( Data[Name] ) ),
    CALCULATETABLE (
        VALUES ( Data[Name] ),
        USERELATIONSHIP ( Calc[Year2], Year[Year] )
    )
)

New Customer =

CALCULATE(DISTINCTCOUNT('Quotes Estimates US'[CustCode]),

CALCULATETABLE(

values('Quotes Estimates US'[Job Start Year]),

'Quotes Estimates US'[Job Start Year]= year('Quotes Estimates US'[Customer Created Date)),

CALCULATETABLE(

values('Quotes Estimates US'[job start month]),

'Quotes Estimates US'[job start month] = month('Quotes Estimates US'[customer created date)))))

[reh169]

@smpa01  How do I attach an excel file?

[smpa01]

Can you please share it through Google/One Drive and clearly mention the output you expect.