• Skip to main content
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Data Stories
    • Power BI Stories
    • 1 dataset, 100 matplotlib visualizations
  • Learning Portal
    • Download Center
    • 25 Days Challenge
    • DAX Glossary
    • Power BI
    • Power BI by Topic
    • Python
    • 1 dataset, 100 matplotlib visualizations
  • Courses
    • Power BI Mini Master Class 1: Using a REST API as a data source
    • Power BI Master Class 1: COVID Tracker
    • Introduction to Power BI – FREE Online course
    • M Language + Power Query Course Bundle
    • Power Query Online Training [updated 2022]
    • M Language Online Course: The unofficial and Practical Reference Guide [updated 2025]
    • My Courses
  • Shop
    • Courses
    • Master Classes
    • Template Apps
    • JSON Themes
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Search
  • Contact
You are here: Home / CM Tooltip Glossary Pro+ / FORMAT

FORMAT

posted on August 15, 2017

« Back to Glossary Index

Syntax

FORMAT(<value>, <format_string>)

Tutorial with example

In today’s video we will go through FORMAT function in DAX. We will learn how to use pre-formated functions and custom functions to format numbers and dates using DAX.

Keynotes:
01:00 Microsoft documentation on FORMAT DAX function
02:23 Pre-defined number formatting: “General Number”
03:30 Pre-defined number formatting: “Currency”
04:38 Pre-defined number formatting: “Fixed”
05:10 Pre-defined number formatting: “Standard”
06:00 Pre-defined number formatting: “Percent”
06:23 Pre-defined number formatting: “Scientific”
07:31 Format numbers without decimals
08:05 Format numbers with four decimals
08:45 Format numbers to millions and thousands
10:18 Format numbers with Leading zeros
10:51 Format numbers with one decimal
11:09 Format numbers with percent symbol
11:25 Format numbers with Scientific symbol
11:53 Pre-defined date formatting: “General Date”
12:10 Pre-defined date formatting: “Long Date”
12:40 Pre-defined date formatting: “Short Date”
12:49 Pre-defined date formatting: “Long Time”
12:50 Pre-defined date formatting: “Medium Time”
12:55 Pre-defined date formatting: “Short Time”
13:17 Format dates to return the Day number
13:22 Format dates to return Month number
13:30 Format dates to get dd-mm-yyyy format

DAX Fridays! #32: FORMAT

Download example file:

To get the files:
1. Go to Curbal Download Center > Dax Fridays
2. Get File #32

Remarks

All predefined formatting strings use the current user locale when formatting the result.

This DAX function is not supported for use in DirectQuery mode.

Was this helpful?
Related Articles:
  • 25 days of DAX Fridays! Challenge – Ed2: World Cup
  • Export Google Analytics data to Microsoft Power BI
  • Google Analytics Template App by Curbal
See Also:
  • EOMONTH
  • FIXED
  • MINUTE
  • MONTH
  • TIME
« Back to Index

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer CTA

Join our community of +50,000 professionals

Become a Member

Subscribe to YouTube

About me:

Curbal AB
Badhusgatan 7B
722 15 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2025 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In