Forum Discussion
Dynamic Column Headings - Dates Over Time
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.
Essentially, I'd like to see week over week # of Hired Employees. The weeks runFriday-Thursday, though.
For example, if my raw data looks like something like this:
| Hires | Region | Effective Date of Hire | Dashboard Refresh Date |
| 1 | Consumer Ret | 1/14/2022 | 1/31/2022 |
| 1 | Consumer Ret | 1/14/2022 | 1/31/2022 |
| 1 | Consumer Ret | 1/14/2022 | 1/31/2022 |
| 1 | Consumer Ret | 1/14/2022 | 1/31/2022 |
| 1 | Consumer Ret | 1/14/2022 | 1/31/2022 |
| 1 | Consumer Ret | 1/20/2022 | 1/31/2022 |
| 1 | Consumer Ret | 1/21/2022 | 1/31/2022 |
| 1 | Consumer Ret | 1/21/2022 | 1/31/2022 |
| 1 | Consumer Ret | 1/27/2022 | 1/31/2022 |
And I'd like it summarized like this
| Hires | |||
| Region | Jan 14-20 | Jan 21-27 | YTD |
| Consumer Ret | 6 | 3 | 9 |
Super UserWhat would be the expected column header for the next week? "Jan 28-Feb 3" ? You may be running out of screen real estate fast.
Hi,
Yes, next column would be Jan 28-Feb 3. I am only planning to show the last 4 weeks.
- lbendlin
PLease 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