FORMAT(value, "")
: Produces string
-532.00 -> -532
0.32 -> 0.32
FORMAT(value, "0")
: Produces string
-532.00 -> -532
0.32 -> 0
FORMAT(value, "0.0" )
: Produces string
-532.00 -> -532.0
10.26 -> 10.3
NOTE: All upper formula produces a string as final result. Can not be sorted as an integer. To sort as an integer, select measure under "measure tools" section, select dynamic
in format
dropdown.
Important Note: #
is for optional place holder and 0
is compulsory place holder.
5. 0.0
: Produces integer
-532.00 -> -532
0.32 -> 0.32
- "00.00": Produces integer
3.2 -> 03.20
- "#.#": Produces integer
-532.00 -> -532
0.32 -> .3
10.00 -> 10
Add Commas to integer:
8. "#,K":
-532.0 -> -532K
0.32 -> K
1,243.00 -> 1243K
- "#,.K":
10.26 -> K
1,243.00 -> 1K
143,498.00 -> 143K
- "0,.#K": Two commas are million, one comma is thousand, 3 = Billion
-532.00 -> -0.5K
10.26 -> 0K
1,243.00 -> 1.2K
- "#%":
0.32 -> 32%
2.00 -> 200%
1,243.00 -> 124300%
- "$0,#.#":
-532 -> -$532
10.26 -> $10.3
1,243 -> $1,243
- "$0,#.#;($0,#.#);zero":
-532.00 -> ($532)
10.26 -> ($10.3)
0.00 -> zero
- FORMAT(MAX(dateTable[DateColumn), "0"):
15 February 2023 -> 44972
- FORMAT(MAX(dateTable[DateColumn), "dd mm yyyy"):
15 February 2023 -> 15 02 2023
- FORMAT(MAX(dateTable[DateColumn), "dd/mm/yyyy"):
/
or " " or "-" are just separators. Any can be used.
15 February 2023 -> 15/02/2023
NOTE: "mmm" -> Jan; "m" -> 1 (and not 01), 12; d -> 1 (and not 01),12; ddd -> Thu, Sun; "q" (->1,2,3,4) gives quarter in which the date belongs to, can be combined with date, month, year. "\Qq" -> Q1,Q2,Q3,Q4.