Calculated column showing just Month and Year

[gbarr12345]

Hi everyone,

I'm hoping you can help me.

I'm trying to create a new calculated column to split up a date to just show Month and Year. I can't seem to find a good calculated column code to do this.

Can anybody help me with this please?

[Jihwan_Kim]

Hi,

Please check the below picture and the attached pbix file.

[gbarr12345]

Hi Jihwan,

Thank you for your reply.

I tried your formula but it still seems to be showing the full month.

Any idea why this is the case?

[Jihwan_Kim · Accepted solution]

Hi,

In case your existing column is text type (if it is not date type), please try something like below.

Please check the below picture and the attached pbix file.

result 01 CC = 
VAR _day =
    DAY ( Data_v2[Month] )
VAR _month =
    MONTH ( Data_v2[Month] )
VAR _year =
    YEAR ( Data_v2[Month] )
RETURN
    FORMAT ( DATE ( _year, _month, _day ), "mmmm-yyyy" )

[gbarr12345]

Apologies, I only got around to seeing this now.

That worked for me so thank you so much!