Format DAX Function in Power BI
The FORMAT DAX function in Power BI converts a value to the text format specified by the format_string.
The function has the following parameters:
- value:
- The value we want to format. This can be a number, date, time, or other data type.
- It can be a column, a measure, or a literal value.
- format_string:
- A string that defines the format to apply to the value.
- The format string specifies how the value should be displayed as text (e.g., currency, percentage, date format, etc.).
- Predefined formats (like "General Number", "Currency", etc.) or custom format strings (like "0.00", "yyyy-mm-dd") can be used.
DAX Syntax FORMAT(value, format_string)
Example: Let’s create a measure.
DAX
Format Measure = FORMAT(TODAY(), "YYYY-MM")
The output of the above dax code is shown below:
Example: Let's create a Calculated column.
DAX
Formatted Column = FORMAT(Query11[Year], "yyyymm")
The output of the above dax code is shown below:
