Dynamic Column headers in Table

[obriaincian]

Hello,

I have a table], the first column is from my source data and the second column within the table is values from a measure. Is there any way for me to make the header for the measure column dynamic to show the current month?

I know a workaround is place a dynamic textbox over it but I'm wondering if there is a better way?

Many thanks

[Jayee · Accepted solution]

@obriaincian 

Have look at this it is in DAX

https://m.youtube.com/watch?v=4emPkBiiCtg

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!

[obriaincian]

@Jayee Do you have any links that shows how to do this?

[Jayee]

Hi @obriaincian ,

You can also write SQL code or DAX to create a table use in Matrix to show as dynamic columns every time dataset refreshes and create a measures to show values.

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!