Forum Discussion
Creating a measure that counts where a created date is between the date parameters
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?
6 Replies
smpa01Community Champion
Anonymouscan you provide some sample data and demonstrate the desired result with the logic to apply to arrive there please
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
Anonymous can you give the source data in an excel table format