Forum Discussion
Help needed graphing a count between a date range
i guess easier will be with sample pbix, let me see if i can put together something quickly for you.
parry2k, thank you for that sample. I notice there are two data tables, with one being a calendar; did you have to manually create this data table?
yes, there are many ways to create it, it is best practice to have continuous date (calendar) table in your model for time intelligence related analysis.
there is dax function called calendar which populate the table with provided date range, link for reference and rest of the columns are just simple formulas, it can also achieved by power query and there are several way to do this, here is link for you to test that. There are many topics and you can search on it.
parry2k, thank you very much for that; it makes way more sense now.
However, in the example, only one date field is used; the 'warranty date', but in my source data there are two date fields that impact the result; the start date and the end date; I don't see how to ensure the count on the [Calendar] date takes into concideration both the warranty start and end dates. Can you help me understand this bit please?
