Forum Discussion

cgallegos's avatar
cgallegos
Regular Visitor
4 years ago
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...
  • lbendlin's avatar
    lbendlin
    4 years ago

    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's avatar
cgallegos
Regular Visitor
4 years ago

Let me know if you need any additional data.

lbendlin's avatar
lbendlin
Super User
4 years ago

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's avatar
    cgallegos
    Regular Visitor
    4 years ago

    Thank you!!