Create a column in my dimension table which says my Month minus 1, current Month so on

[Anonymous]

Hi friends,

I made two dimension CYCLE and Period and a fact with the values below. 

S&OE Cycle (Month)	01/09/2018	01/10/2018	01/11/2018	01/12/2018	01/01/2019	01/02/2019
01/10/2018	2212	21000	1950	1850	1500	1950
01/11/2018	2054	2054	2054	2054	2050	2054

I need a column that says to me when a cycle is selected get the month of the cycle and includ M for the Period which has the same month of the cycle selected, 

I made it work looking at the month of the current date instead of looking at the month of the selected cycle: 

VAR Current_Month_Year = DATE(YEAR(TODAY());MONTH(TODAY());01)

VAR M_MINUS_1        = MONTH(EOMONTH(Current_Month_Year;-1)) & YEAR(EOMONTH(Current_Month_Year;-1))

VAR M        = MONTH(EOMONTH(Current_Month_Year;0)) & YEAR(EOMONTH(Current_Month_Year;0))

VAR M_PLUS_1        = MONTH(EOMONTH(Current_Month_Year;1)) & YEAR(EOMONTH(Current_Month_Year;1))

VAR M_PLUS_2        = MONTH(EOMONTH(Current_Month_Year;2)) & YEAR(EOMONTH(Current_Month_Year;2))

VAR M_PLUS_3        = MONTH(EOMONTH(Current_Month_Year;3)) & YEAR(EOMONTH(Current_Month_Year;3))

RETURN

SWITCH(

MONTH(D_Period[Period]) & YEAR(D_Period[Period]);

M_MINUS_1;0;

M;1;

M_PLUS_1;2;

M_PLUS_2;3;

M_PLUS_3;4;

BLANK()

)

Could anyone help me please?

Regards,
Luiz Gustavo

[v-jiascu-msft]

Hi Luiz,

Could you make it more clear, please?

1. Is the data here in a visualization or in a source table?

2. Is the "a cycle is selected" a slicer visual?

3. Is the desired column in the source table?

Can you share a sample of the original data?

Best Regards,
Dale