Solved: what is the DAX function for Month name date year ...

Anonymous · ‎11-28-2023

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 · ‎11-28-2023

hi, @Anonymous

try below

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

just adjust table name

Dangar332 · ‎11-28-2023

hi, @Anonymous

try below

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

Anonymous · ‎11-28-2023

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 · ‎11-28-2023

hi, @Anonymous

try below

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

just adjust table name

Anonymous · ‎11-28-2023

Its working Now.. thank you for quick response

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