Forum Discussion

MStark's avatar
MStark
Helper III
11 months ago
Solved

Dynamic Headers in DAX

Hey all! Im working on a query and wondering how to get header dates to be dynamic. Right now Im summarizing columns with the actual date but need this to be updated to be dynamic so can just set ...
Need Help
  • tayloramy's avatar
    tayloramy
    11 months ago

    Hi MStark, 

     

    What tools are you using? As far as I know DAX wasn't designed to be able to handle this and can't do it.  

    If this helps, please consider giving Kudos. If it solves your problem, mark it as the solution so others can find it faster.

     
  • ZhangKun's avatar
    ZhangKun
    11 months ago

    DAX queries cannot generate dynamic column headers. You can use alternative solutions:

    1. Filter rows for the last five days in Power Query. See the attached example for a simple example. (For testing, you'll need to manually set your computer's time, but remember to turn "Set Automatic Time" back on.)

    2. Use headers like "1 Day Ago" and "2 Days Ago."

v-sgandrathi's avatar
v-sgandrathi
Community Support
11 months ago

Hi MStark,

 

Has your issue been resolved?
If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you tayloramy for your conversation in the threads and your continuous effort in resloving the queries.

 

Thank you for your understanding!

  • v-sgandrathi's avatar
    v-sgandrathi
    Community Support
    11 months ago

    Hi MStark,

     

    As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.

     

    Thank you for your cooperation. Have a great day.

    • v-sgandrathi's avatar
      v-sgandrathi
      Community Support
      11 months ago

      Hi MStark,

       

      We haven’t heard from you on the last response and was just checking back to see if your query was answered. Otherwise, will respond back with the more details and we will try to help .

      Please let us know if there’s anything else we can do to help.

       

      Thakn you.