Switch Statement for a Calader to find last 3 months

[amaleranda]

Hi DAX Gurus,

I have a requirment to instert a tag for a last three month period into a continues date tabel. It works fine for last two months but it seems to have issue when I try to get the thrid month. below is my formula. I can see both 1 and 2 in the date tabel but I cannot see 3 in my date table column.

CurrentMonth1 = 

SWITCH(

TRUE(),

YEAR([Date]) = YEAR(TODAY()) && MONTH([Date]) = MONTH(TODAY())-1,1,

YEAR([Date]) = YEAR(TODAY()) && MONTH([Date]) = MONTH(TODAY())-2,2,

YEAR([Date]) = YEAR(TODAY()) && MONTH([Date]) = MONTH(TODAY())-3,3,

100

),