what is the DAX function for Month name date year in power bi

[Anonymous]

Hi Team,

Looking for the concern on the how we can write DAX function for the below requirement.

Date - 28-11-2023

Requirement is --- November 18,2023

Kindly check and do the needful.

[Dangar332]

hi, @Anonymous 

try below

FORMAT(DATE(2023,11,28),"mmmm dd, yyyy")

[Anonymous]

Hi Thanks for quick reply,

I have connected with live data and date should be keep on going on..and need to change every time when we selected 

[Dangar332 · Accepted solution]

hi, @Anonymous 

try below

FORMAT(MIN('Table 2'[Date]),"mmmm dd, yyyy")

just adjust table name 

[Anonymous]

Its working Now.. thank you for quick response