Forum Discussion
Solved
Dynamic Column Headings - Dates Over Time
Hi - I am wanting to have column headings that change as my dashboard is refreshed or updated. For example, I'd like the below "current week" heading to say "Jan 14-20" as the values in that col...
I initially implemented this as a DAX calculated column but then realized this would not work as it doesn't sort the result correctly. I reverted back to the standard method of supplying an external calendar table instead. See attached for both options.
lbendlin
Super User
Super UserPLease add some more sample data so it covers that whole period.
Raw Data:
| Hires | Region | Effective Date of Hire |
| 1 | Consumer Ret | 1/14/2022 |
| 1 | Consumer Ret | 1/14/2022 |
| 1 | Consumer Ret | 1/14/2022 |
| 1 | Consumer Ret | 1/14/2022 |
| 1 | Consumer Ret | 1/14/2022 |
| 1 | Consumer Ret | 1/20/2022 |
| 1 | Consumer Ret | 1/21/2022 |
| 1 | Consumer Ret | 1/21/2022 |
| 1 | Consumer Ret | 1/27/2022 |
| 1 | Consumer Ret | 1/28/2022 |
| 1 | Consumer Ret | 1/28/2022 |
| 1 | Consumer Ret | 2/3/2022 |
| 1 | Consumer Ret | 2/3/2022 |
| 1 | Consumer Ret | 2/3/2022 |
| 1 | Consumer Ret | 2/4/2022 |
| 1 | Consumer Ret | 2/4/2022 |
| 1 | Consumer Ret | 2/10/2022 |
| 1 | Consumer Ret | 2/10/2022 |
Week Over Week - What I'd Like to Get to
| Region | Jan 14-20 | Jan 21-27 | Jan 28-Feb 3 | Feb 4 - Feb 10 | YTD |
| Consumer Ret | 6 | 3 | 5 | 4 | 18 |