UPPER
A text in upper case.
Group: Text. Compatible with DAX.
Syntax
UPPER ( <text> )| Parameter | Type | Description |
|---|---|---|
text | Text | The text to write in capitals; a number becomes text first. |
Returns
Text. The text with every small letter made a capital.
Remarks
- Only letters change; digits and signs stay as they are. ø becomes Ø; ß has no capital of its own here and stays ß.
- A blank gives BLANK.
- Comparing texts with
=already ignores case; UPPER is for showing text, or forEXACTandFIND, where case counts.
Examples
Capitals
EVALUATE
ROW ( "lettøl", UPPER ( "lettøl" ), "straße", UPPER ( "straße" ), "12", UPPER ( 12 ) )| lettøl | straße | 12 |
|---|---|---|
| LETTØL | STRAßE | 12 |
The products in capitals
EVALUATE
SELECTCOLUMNS (
Products,
"Product", Products[Product],
"Upper", UPPER ( Products[Product] )
)
ORDER BY [Product]| Product | Upper |
|---|---|
| Cider | CIDER |
| IPA | IPA |
| Lettøl | LETTØL |
| Pils | PILS |