Dynamic Column Headings - Dates Over Time

[cgallegos]

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 column are calculated for that date range. Is there a way to do this?

Thank you,

[lbendlin]

If by "dynamic"  you mean "recalculated during every import mode dataset refresh"  then yes.  Otherwise please provide more details, some sample data would be nice too.

[cgallegos]

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

[lbendlin]

What would be the expected column header for the next week?  "Jan 28-Feb 3" ?  You may be running out of screen real estate fast.

[cgallegos]

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.

[cgallegos]

Let me know if you need any additional data.

[lbendlin · Accepted solution]

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.

[cgallegos]

Thank you!!

[cgallegos]

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