Forum Discussion
Dynamic Date Headers
The 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?
Arrears Stage | KPI1 | 201908 | KPI2 | 202008 | 202007 | 201909 | KPI3 | 20200926 | KPI4 | 20200826 |
| Current | 0 | 10.00% | 1 | 1.00% | 2.00% | 1.00% | 0 | 2.00% | 1 | 1.00% |
| Cycle 1 | 0 | 30.00% | 1 | 40.00% | 30.00% | 30.00% | 0 | 30.00% | 1 | 20.00% |
| Cycle 2 | 0 | 60.00% | 1 | 50.00% | 50.00% | 50.00% | 0 | 50.00% | 1 | 50.00% |
| Cycle 3 | 0 | 80.00% | 1 | 70.00% | 50.00% | 55.00% | 0 | 60.00% | 1 | 40.00% |
| NPL | 1 | 5.00% | 0 | 4.00% | 5.00% | 1.00% | 1 | 3.00% | 0 | 3.00% |
| Total | 0 | 4.00% | 1 | 2.00% | 2.00% | 4.00% | 0 | 3.00% | 1 | 3.00% |
| 201908<202008 | 201908>202008 | 20200926<20200826 | 20200926>20200826 |
Hi Anonymous ,
Is the import of the information in the first format or the second one?
Hi Anonymous ,
I was abble to get a working solution working with unpivot and creating a middle step to get the column names and sort the information in the I also create some measure for condittional formatting be aware that this may needs some changes.
Check PBIX file attach, and experiment with other information wiht different dates.