I have a table in which the transaction amount for each consecutive period is caculated based on the date selected. Each of these calculations are columns in the table i.e. period 1, period 2, period 3, each with the calculated tran amount (based on cetain critereia related to the selected date).
What I am trying to do now, is to replace the column names, period1, period2 etc with MM YYYY. So if 31/01/2024 is selected, the column headers will be 01-2024, 02-2024 etc. I have tried using a parameter with variables on the selecetd date from a slicer with a 'before' property. This is from a stand alone date table.
Parameter =
Var per0 = FORMAT(DATE(YEAR(MAX(SelectedDate[Date])), MONTH(MAX(SelectedDate[Date]))+1,+1),"MMM YYYY")
Var per1 = FORMAT(DATE(YEAR(MAX(SelectedDate[Date])), MONTH(MAX(SelectedDate[Date])),+2),"MMM YYYY")
Var per2 = FORMAT(DATE(YEAR(MAX(SelectedDate[Date])), MONTH(MAX(SelectedDate[Date]))+3,1),"MMM YYYY")
Var per3 = FORMAT(DATE(YEAR(MAX(SelectedDate[Date])), MONTH(MAX(SelectedDate[Date]))+4,1),"MMM YYYY")
Var per4 = FORMAT(DATE(YEAR(MAX(SelectedDate[Date])), MONTH(MAX(SelectedDate[Date]))+5,1),"MMM YYYY")
Var per5 = FORMAT(DATE(YEAR(MAX(SelectedDate[Date])), MONTH(MAX(SelectedDate[Date]))+6,1),"MMM YYYY")
Var per6 = FORMAT(DATE(YEAR(MAX(SelectedDate[Date])), MONTH(MAX(SelectedDate[Date]))+7,1),"MMM YYYY")
Var per7 = FORMAT(DATE(YEAR(MAX(SelectedDate[Date])), MONTH(MAX(SelectedDate[Date]))+8,1),"MMM YYYY")
Var per8 = FORMAT(DATE(YEAR(MAX(SelectedDate[Date])), MONTH(MAX(SelectedDate[Date]))+9,1),"MMM YYYY")
Var per9 = FORMAT(DATE(YEAR(MAX(SelectedDate[Date])), MONTH(MAX(SelectedDate[Date]))+10,1),"MMM YYYY")
Var per10 = FORMAT(DATE(YEAR(MAX(SelectedDate[Date])), MONTH(MAX(SelectedDate[Date]))+11,1),"MMM YYYY")
Var per11 = FORMAT(DATE(YEAR(MAX(SelectedDate[Date])), MONTH(MAX(SelectedDate[Date]))+12,1),"MMM YYYY")
Var per12 = FORMAT(DATE(YEAR(MAX(SelectedDate[Date])), MONTH(MAX(SelectedDate[Date]))+13,1),"MMM YYYY")
Return
{
(per1, NAMEOF('TS_PBI_RevDeferrals_Balance'[Period 1A+]), 0),
(per2, NAMEOF('TS_PBI_RevDeferrals_Balance'[Period 2A+]), 1),
(per3, NAMEOF('TS_PBI_RevDeferrals_Balance'[Period 3A+]), 2),
(per4, NAMEOF('TS_PBI_RevDeferrals_Balance'[Period 4A+]), 3),
(per5, NAMEOF('TS_PBI_RevDeferrals_Balance'[Period 5A+]), 4),
(per6, NAMEOF('TS_PBI_RevDeferrals_Balance'[Period 6A+]), 5),
(per7, NAMEOF('TS_PBI_RevDeferrals_Balance'[Period 7A+]), 6),
(per8, NAMEOF('TS_PBI_RevDeferrals_Balance'[Period 8A+]), 7),
(per9, NAMEOF('TS_PBI_RevDeferrals_Balance'[Period 9A+]), 8),
(per10, NAMEOF('TS_PBI_RevDeferrals_Balance'[Period 10A+]), 9),
(per11, NAMEOF('TS_PBI_RevDeferrals_Balance'[Period 11A+]), 10),
(per12, NAMEOF('TS_PBI_RevDeferrals_Balance'[Period 12A+]), 11)
But this is not giving me the correct result. Is there a way in which to acheive this on a table visual?
