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.
DaveAl the best way to deal with it, is to use a calendar table.
Bring axis (slicer, date values from-to) from calendar table. At the same time create a calculated colum in the calendar table that would assign the the "Period" classification from the above to table to there.
End users uses the values from calendar table and it would corrrectly slice the vize according to the Period (custom Period defined by you)