Return current month name in a calculated column

[Anonymous]

Hi

I have a table following

Date                                

04-04-2019

01-01-2019

02-02-2019

if  Date coumn having current month then return a current monthe name(Apr) 

Expect as following

Date                    Calculated column               

04-04-2019              Apr

01-01-2019            

02-02-2019

16-04-2019             Apr

how can i achieve this one?

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

Just use this simple formula to add a column

Column = IF(YEAR('Table'[Date])=YEAR(TODAY())&&MONTH('Table'[Date])=MONTH(TODAY()),FORMAT ( 'Table'[Date], "mmm" ) )

Result:

Best Regards,
Lin