Format a Date in a Power BI Measure

You can use the FORMAT function in DAX to control how dates are displayed in Power BI measures. Here’s a simple example:

DAX:

FormattedDate = FORMAT([DateColumn], “MMMM DD, YYYY”)

This will format your date as “October 23, 2024” (Month Day, Year). You can use different format strings depending on your needs:

  • “MM/DD/YYYY” for Month/Day/Year (e.g., 10/23/2024)
  • “DD-MM-YYYY” for Day-Month-Year (e.g., 23-10-2024)
  • “YYYY-MM-DD” for Year-Month-Day (e.g., 2024-10-23)

If you’re working with null or blank values, you can handle them like this:

DAX:

FormattedDateWithCheck = IF(ISBLANK([DateColumn]), “No Date”, FORMAT([DateColumn], “MMMM DD, YYYY”))

This ensures that blank values are displayed as “No Date” instead of causing errors.

Need Help With QA Automation?

Work with our skilled full stack experts to improve your software quality, accelerate testing cycles, and enhance overall performance.

Hire QA

Support On Demand!

Related Q & A

Services

Web Designer
Ecommerce Development
Microsoft App Development
Open Source Development
Content Management System
Custom Software Development
IT Consulting
Hire Us

Our Expertise

Travel Portal Devlopment
Event Management Software
Transport and Logistics software
Cloud Computing
Custom CRM Software Development
Enterprise Mobility Solutions
Education / E-Learning
Startup Consulting
Booking Widgets

Hire Developers

Hire Web Designer
Hire Web Developers
Hire ASP.NET Developers
Hire ASP.Net Core Developers
Hire WordPress Developers
Hire E-Commerce Developers

Technologies

ASP.NET Zero
ASP.NET Core
Boilerplate
Umbraco
Kentico
ASP.NET
C#
Craft CMS
Shopify
Wordpress
Niotechone Software Solution Pvt. Ltd. company logo

Contact For Sales

sejal@niotechone.com

sales@niotechone.com

Sales +91 9925 66 2323

Sales +91 9925 66 8383

Contact For Careers

career@niotechone.com

HR +91 99244 08252

India

3rd Floor, Aval Complex, University Road, above Balaji Super Market, Panchayat Nagar Chowk, Indira Circle, Rajkot, Gujarat 360005.

Outline of the Statue of Unity representing India location for Niotechone

Canada

Abbotsford, BC

Illustration of Canada city skyline including CN Tower and modern buildings

Dubai

15th B Street 103, al Otaiba Dubai DU 00000, United Arab Emirates

Burj Al Arab luxury hotel in Dubai skyline
GoodFirms partner
DesignRush
Web & Mobile Application Development Company-Niotechone - Client
Web & Mobile Application Development Company-Niotechone - Client
Web & Mobile Application Development Company-Niotechone - Client
Web & Mobile Application Development Company-Niotechone - Client
Web & Mobile Application Development Company-Niotechone - Client
Web & Mobile Application Development Company-Niotechone - Client
Linkedin Youtube Instagram Facebook Twitter Whatsapp Dribbble Github Gitlab
Niotechone Software Solution Pvt. Ltd. company logo

Contact For Sales

sejal@niotechone.com

sales@niotechone.com

Sales +91 9925 66 2323

Sales +91 9925 66 8383

India

3rd Floor, Aval Complex, University Road, above Balaji Super Market, Panchayat Nagar Chowk, Indira Circle, Rajkot, Gujarat 360005.

Outline of the Statue of Unity representing India location for Niotechone

Canada

Abbotsford, BC.

Illustration of Canada city skyline including CN Tower and modern buildings

Dubai

15th B Street 103, al Otaiba Dubai DU 00000, United Arab Emirates.

Burj Al Arab luxury hotel in Dubai skyline

Contact For Careers

career@niotechone.com

HR +91 99244 08252

GoodFirms partner
DesignRush

Copyright © 2026 Niotechone Software Solution Pvt. Ltd. All Rights Reserved.