Dynamic Title with month name

[Anonymous]

Hi   I created the Dynamic Title measure for the filter data from slicer table.  and my slicer data is 1st Feb 2020.

but the result showing  - Total YTD 01/02/2020.   i just need the month name alone not the date format.  below is my measure..can someone fix this.

Title YTD = IF(ISCROSSFILTERED(Rundate[KPI_MONTH])," Total YTD " & FIRSTNONBLANK(Rundate[KPI_MONTH], TRUE), "Total YTD ")

Thanks

Kavitha Ghosh

[amitchandak · Accepted solution]

@Anonymous ,

Try to use format

Title YTD = IF(ISCROSSFILTERED(Rundate[KPI_MONTH])," Total YTD " & format(FIRSTNONBLANK(Rundate[KPI_MONTH], TRUE),"MMM YYYY"), "Total YTD ")

Change format as per need

[Anonymous]

Thanks Amit!!!!