Power Fx function
Text — Power Fx function reference
Number to formatted text.
Syntax
powerfx
Text( Value [, Format ] [, LanguageCode ] )
Examples
powerfx
Text(1234.5, "#,##0.00")
→ "1,234.50"
powerfx
Text(1234.5, "#,##0.00")
powerfx
Text(percentComplete, "0%")
Common mistakes & gotchas
- Without a Format argument, Text() uses a generic default that may show more or fewer decimals than expected — always pass an explicit format for user-facing currency or percentages.
- Format strings are Excel-style custom number codes (0.00, #,##0, 0%), not printf/.NET-style codes — mixing conventions from other platforms is a common bug.
Related Power Fx functions
From Data conversion