Format DAX Function

The FORMAT function converts a value to text according to the specified format.

DAX Syntax FORMAT(value, format_string)

Example: Create a Calculated column.

DAX

Formatted Column = FORMAT(Query11[Year], "yyyymm")
FORMAT dax function