ISFILTERED function as Month

[icdns]

Hi, 

I would like to ask for your help in converting my MM/DD/YYYY to Month alone. I have a month filter in my report, if a specific month is filtered, it will show as a label. I have used a ISFILTERED function, it's working. However, instead of Month alone it is showing as MM/DD/YYYY

Example: 

Filter: 

Month: February 2020

Is Filtered Label: 02/29/2020 

TO 

(expectation)

Filter: 

Month: February 2020

Is Filtered Label: February 2020

Thanks!

[Fowmy · Accepted solution]

@icdns 

To covert as you expect in your table as new column:

Month Year = FORMAT(TABLE[DATE],"MMMM YY")


If it is a measure then:

Month Year = FORMAT(SELECTEDVALUE(TABLE[DATE]),"MMMM YY")