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.
Hi DaveAl
As AlexisOlson and smpa01 recommended, you do need a calendar table, then you can create a measure to get the period.
If you need more help, you can @ me.
Is the above answer helpful? Could you accept the answer helpful as the solution? Thanks
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.