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.
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 Let me know if you need any additional data.
- lbendlin
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.