I want to add some text + field name to a title of a visual

[Benc7777]

Morning / Afternoon everyone,

Im  sorry for being so basic, but im new to DAX (I wish it was the same as SQL)

So I have read up on a dynamic title and it like like I have to create a measure and then add this into the dynamic part of the title within the visual.

I have tried

Title = ISTEXT("Est Next Delivery" + MIN('Nextdel'[Delivered]))

But im obviouslyu being stupid as this doent work.

I just need the Text "Est Next Delivery" followed by the date in DD/MM/YY format from the field 'Nextdel'[Delivered] , there are many dates in this column but they are all the same.

If anyone has the time to help I would be most appriciative.

Thx

B

[FreemanZ]

hi @Benc7777 ,

try like:

Title = "Est Next Delivery" & MIN('Nextdel'[Delivered])

[Benc7777]

Brilliant thanks @FreemanZ 

Is there anyway to get it DD/MM/YYYY ? The field 'Nextdel'[Delivered] is set to dd/mm/yyyy ?

[FreemanZ · Accepted solution]

hi @Benc7777 ,

you mean like this?

Title = "Est Next Delivery" & FORMAT(MIN('Nextdel'[Delivered]), "dd/mm/yyyy")

[Benc7777]

Brilliant, many thanks indeed.

Appriciate your help