Return current month name in a calculated column

Question

Hi&nbsp;I have a table following&nbsp;Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;04-04-201901-01-201902-02-2019if&nbsp; Date coumn having current month then return a current monthe name(Apr)&nbsp;&nbsp;Expect as following&nbsp;Date&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Calculated column&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;04-04-2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Apr01-01-2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;02-02-201916-04-2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Apr&nbsp;how can i achieve this one?&nbsp;&nbsp;&nbsp;

v-lili6-msft · Accepted Answer

hi,&nbsp;Anonymous&nbsp;
Just use this simple formula to add a column
Column = IF(YEAR('Table'[Date])=YEAR(TODAY())&amp;&amp;MONTH('Table'[Date])=MONTH(TODAY()),FORMAT ( 'Table'[Date], "mmm" ) )
Result:

&nbsp;
Best Regards,Lin

Forum Discussion

Return current month name in a calculated column

1 Reply

Related content

How to make a DAX calculation return BLANK rows

Dynamic Market Return Calculations

If Statement Calculated Column Returning Incorrectly

Calculations with measures return odd results

CALCULATE returns blank values