Forum Discussion
Issue with Dynamic format strings for measures
Hi All, this is my first post here and I hope I am doing it correctly. Otherwise please let me know. My issue/ challenge is as follows: I would like to display all results/values <1000 as is,...
Irwan
Super User
Super UserHello DieDybi ,
please check if this result accomodate your need.
Column Rename =
SUBSTITUTE(
IF(
'Table'[Sum of Data]>1000,
FORMAT('Table'[Sum of Data]/1000,"$#,0.0K"),
FORMAT('Table'[Sum of Data],"$#")
),
".",
"," //substitute . to , as FORMAT use . as separator
)
Remove $ symbol it you dont need it (i am only put it as additional information).
Please be aware, this renaming will make those number as TEXT.
Hope this will help you.
Thank you.