If I have a column of dates, associated with a column of "week of" that in itself is the MIN(calendar_date) - MAX(calendar_date) for each week, and the user has applied a Month filter (lets say November as an example), is there a way I can have a measure OR column that displays a slightly changed header showing that specific column is missing dates?
Example
Week of 10/27/2024 - 11/02/2024 when filtered by Month = November would only aggregate the data from 11/01 - 11/02.
Can the header instead show Week of 10/27/2024 - 11/02/2024*
Alternatively it could instead use the filtered MIN/MAX as Week of 11/01/2024 - 11/02/2024
I had a measure created that was doing it correctly in a table on rows (as long as I had the related column [Week] as well, but I couldn't use the measure as a "column". I've tried SUMMARIZE and SUMMARIZECOLUMNS, but it's not cooperating.
| Month | Week of | Calendar Date | Value |
| October | 10/27/2024 - 11/02/2024 | 10/27/2024 | 1 |
| October | 10/27/2024 - 11/02/2024 | 10/28/2024 | 2 |
| October | 10/27/2024 - 11/02/2024 | 10/29/2024 | 1 |
| October | 10/27/2024 - 11/02/2024 | 10/30/2024 | 2 |
| October | 10/27/2024 - 11/02/2024 | 10/31/2024 | 1 |
| November | 10/27/2024 - 11/02/2024 | 11/01/2024 | 1 |
| November | 10/27/2024 - 11/02/2024 | 11/02/2024 | 2 |
| November | 11/03/2024 - 11/09/2024 | 11/03/2024 | 3 |
| November | 11/03/2024 - 11/09/2024 | 11/04/2024 | 1 |
| November | 11/03/2024 - 11/09/2024 | 11/05/2024 | 4 |
| November | 11/03/2024 - 11/09/2024 | 11/06/2024 | 1 |
| November | 11/03/2024 - 11/09/2024 | 11/07/2024 | 2 |
| November | 11/03/2024 - 11/09/2024 | 11/08/2024 | 2 |
| November | 11/03/2024 - 11/09/2024 | 11/09/2024 | 1 |
| November | 11/10/2024 - 11/16/2024 | 11/10/2024 | 1 |
| November | 11/10/2024 - 11/16/2024 | 11/11/2024 | 1 |
| November | 11/10/2024 - 11/16/2024 | 11/12/2024 | 1 |
That's the general structure of underlying data. Months are setup as a slicer with current month pre-filtered and the view is month over month aggregate data. If the user switches to see a week over week view it would look like this:
| | 10/27/2024 - 11/02/2024 | 11/03/2024 - 11/09/2024 | 11/10/2024 - 11/16/2024 |
| Aggregate row for Value | 3 (excludes 10/27-10/31) | 14 | 3 |
| | | | |
It's not immediately clear that the week of 10/27-11/02 is filtering out the data from October.
