topic Re: what is the DAX function for Month name date year in power bi in DAX Commands and Tips

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

Anonymous — Tue, 28 Nov 2023 16:02:56 GMT

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 — Tue, 28 Nov 2023 16:07:49 GMT

hi, Anonymous

try below

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

Anonymous — Tue, 28 Nov 2023 16:16:53 GMT

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 — Tue, 28 Nov 2023 16:21:23 GMT

hi, Anonymous

try below

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

just adjust table name

Anonymous — Tue, 28 Nov 2023 16:31:34 GMT

Its working Now.. thank you for quick response