How to display month name and year that are extracted from date column in Card?

[Anonymous]

Hi, I need help to extract month (text field) and year (numerical field) in the Card?

Currently, I am able to display the last completed date in the card in full format

But I want only "Jun-19" to be displayed in the card.

My data field:

But when I tried to create a new measure:

MonthYear completed = concatenate (month (XX), year(XXX). The column that I wanted for Month does not appear for Month and Year as I do not have any calculated column for me to select for month and year. 

I have tried to create a new column with "Related" DAX function but it does not work for me.

How do I do that to display month and year only in the card only?

Thanks

[Fowmy · Accepted solution]

@Anonymous 

Please try the following measure:

Completed Month and Year = 

FORMAT( MAX(Table[Completed Date]) , "Mmm" ) && " - " && 
FORMAT( MAX(Table[Completed Date]) , "YYYY" )

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[Fowmy]

@Anonymous 

I think the closing brackets are not correctly placed, please recheck.

Add one ) after "Mmm" and remove the last )

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[Anonymous · Accepted solution]

Hi 
I have changed it to other formula

CONCATENATE(FORMAT(MAX(Program[Date Completed]), "Mmm"), CONCATENATE( "-",FORMAT(MAX(Program[Date Completed]), "YYYY")))

It works.

Thanks!

[Fowmy · Accepted solution]

@Anonymous 

Please try the following measure:

Completed Month and Year = 

FORMAT( MAX(Table[Completed Date]) , "Mmm" ) && " - " && 
FORMAT( MAX(Table[Completed Date]) , "YYYY" )

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[Anonymous]

@Fowmy 

Hi, thanks

There is no error in DAX but it cannot be displayed correctly in the card.