Forum Discussion
Return current month name in a calculated column
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...
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
v-lili6-msft
Community Support
Community Supporthi, 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