Forum Discussion
Dynamic Date Headers
I created a table with dates that updates every week. I created a straight table where I list all the fields with icons (KPI). You will see the dates are ordered as the OrderID above....
MFelix
Super User
Super UserThe issue comes when you make the unpivot of the columns, based on the date, since the date are always updating you are getting new column headers and that is not matching your data.
Believe that the best way is using the original data and then use DAX to make the calculations for the table.
Can you share a sample of the data?
MFelix
Anything else you can think of?
thanks for the help thus far.
please see more data attached, should the data not be sufficient.
| Stages | dates | rates |
| Current | 201909 | 1% |
| Current | 201910 | 2% |
| Current | 202008 | 3% |
| Current | 202009 | 4% |
| Current | 20200903 | 5% |
| Current | 20201003 | 6% |
| Cycle 1 | 201909 | 30% |
| Cycle 1 | 201910 | 31% |
| Cycle 1 | 202008 | 32% |
| Cycle 1 | 202009 | 33% |
| Cycle 1 | 20200903 | 34% |
| Cycle 1 | 20201003 | 35% |
| Cycle 2 | 201909 | 40% |
| Cycle 2 | 201910 | 41% |
| Cycle 2 | 202008 | 42% |
| Cycle 2 | 202009 | 43% |
| Cycle 2 | 20200903 | 44% |
| Cycle 2 | 20201003 | 45% |
| Cycle 3 | 201909 | 50% |
| Cycle 3 | 201910 | 51% |
| Cycle 3 | 202008 | 52% |
| Cycle 3 | 202009 | 53% |
| Cycle 3 | 20200903 | 54% |
| Cycle 3 | 20201003 | 55% |
| NPL | 201909 | 7% |
| NPL | 201910 | 8% |
| NPL | 202008 | 9% |
| NPL | 202009 | 10% |
| NPL | 20200903 | 11% |
| NPL | 20201003 | 12% |
| Total | 201909 | 20% |
| Total | 201910 | 21% |
| Total | 202008 | 22% |
| Total | 202009 | 23% |
| Total | 20200903 | 24% |
| Total | 20201003 | 25% |