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.
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.
