Dimension range Today minus 1 year in month Name

[Oguzhan]

Hello,

I am currently trying to visualize a stacked bar char with the Date as a dimension. My problem is that I need the dimension to be restricted with today()  - 1 year in the date type Monthname(), my actual code seems to work but it doesn't show me the actual month. It only shows the completed months but I need also the actual month even though its not completed yet.

My Dimension is AW.CanonicalDate

=If(MonthName([AW.CanonicalDate]) >= MonthStart(AddYears(Today(), -1)) and MonthName([AW.CanonicalDate]) <= Monthstart(Today()) And MonthName([AW.CanonicalDate]) <= today(), MonthName([AW.CanonicalDate]))

Can you pleas help me