cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## 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 following

Date                    Calculated column

04-04-2019              Apr

01-01-2019

02-02-2019

16-04-2019             Apr

how can i achieve this one?

1 ACCEPTED SOLUTION
Community Support

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.