formula for converting year & month from text to make comparison

[Arif270182]

Hi

I need support in converting my data which consist of months and year e.g. as below 

01 2017

02 2017

03 2017 

04 2017 & so far and so good & 

01 2018

02 2018

03 2018

04 2018 in same way 

the support what i need is to convert 2017 as Last year (LY) & 2018 as current year (CY) in order to compare month 1 CY vs LY.

Appreciate your feedback

regards 

[Greg_Deckler · Accepted solution]

Not 100% on what you are going for here but perhaps this:

Column = IF(RIGHT([Column1],4)="2017","LY","CY")

[v-yulgu-msft · Accepted solution]

Hi @Arif270182,

Please new measures:

CY = CALCULATE(SUM(table4[Sales]),FILTER(table4,table4[Year]=YEAR(TODAY())))

LY = CALCULATE(SUM(table4[Sales]),FILTER(table4,table4[Year]=YEAR(TODAY())-1))

Use a table visual to display data.

Best regards,

Yuliana Gu

[Greg_Deckler · Accepted solution]

Not 100% on what you are going for here but perhaps this:

Column = IF(RIGHT([Column1],4)="2017","LY","CY")

[Arif270182]

Hi 

thanks for below update it worked but now i have another challange  in arranging month from Jan to Dec, I have already arranged table month column  month sequence not arranged

how can i fix this sequence