topic Re: dynamic number formating (negative numbers) in DAX Commands and Tips

dynamic number formating (negative numbers)

Sofinobi — Mon, 26 Jun 2023 07:31:31 GMT

good morning all,

i have a code formating for numbers, it's ok, but i need the same part for the negative numbers, please how can i perform that

VAR salesMeasure = [Sales]

return SWITCH(TRUE(),

salesMeasure<10000,"#,0",

salesMeasure<1000000, "#,.00 K",

salesMeasure<1000000000, "#,,.00 M" ,

salesMeasure>=1000000000, "#,,,.00 B")

thank you

Sofinobi — Mon, 26 Jun 2023 07:59:08 GMT

i find the solution by modifiying the code like this, i'll keep the post for other members,

VAR salesMeasure = [Sales]

return SWITCH(TRUE(),

salesMeasure>=1000000000, "#,,,.00 B",

salesMeasure>=1000000, "#,,.00 M" ,

salesMeasure>=10000, "#,.00 K",

salesMeasure>=0,"#,0",

salesMeasure>-10000,"#,0",

salesMeasure>-1000000, "#,.00 K",

salesMeasure>-1000000000, "#,,.00 M" )