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....
Hi Anonymous ,
Are the table you make then unpivot to give column values? To what I can see you have each date as a column on your model correct?
That is correct and the KPI's (red and green icons) calculates the difference for date 1 and 2 and the same for column 5 and 6. Its a table and not a matrix visual.
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