calendar table - flag last full month

[Pbiuserr]

Hello,

I've created calculated column 

LFM = Switch( True(),

eomonth('Calendar'[Date],0)= eomonth(Today(),-1),"Last Full Month",

Format('Calendar'[Date],"MMM YYYY")

)

It works nearly perfect, but for example today I have Last Full Month from 30 April to 30 May. It supposed to be 1st of May till 31st of May as Last Full Month. Tommorow (1.07.2022) it supposed to be 1.06.2022 - 30.06.2022

Can someone help me with that?

edit: can someone remove this thread? I've had a visual bug, everything is fine

[amitchandak · Accepted solution]

@Pbiuserr , The above code is correct. I really doubt it can give that output .

Just create the column again and check

I use similar stuff

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

Can you share  a sample pbix after removing sensitive data.