Forum Discussion
Solved
Date Ranges Without a Row for Each Date
Hello All, I've got a client dataset that includes non-standard date groupings, and they're expressed as ranges with StartDate and EndDate. It's 10+ years worth of data, so I'd rather not generat...
As I mentioned in the initial question, a calendar table is not an acceptable solution for my client.
That said, I did figure it out myself. If anyone is looking to do something similar, you can use CALCULATE and FILTER([Date] >= [StartDate] && [Date] <= [EndDate]).
Thanks for all your help.
A row per day (a calendar date dimension table) is the simplest solution. 10 years * 365 days/year is only a few thousand rows, which is tiny compared to what Power BI can handle. You typically want a calendar table for modeling purposes anyway.