Solved: $ sign currency for only few rows based upon condi... - Page 2

Anonymous · ‎02-24-2020

Hi @all,

Please let me know if I can make changes to the currency only for few values in a column.
For Example: If the type is Quantity then Value is 39. If the Type is Dollar then value is $540.

Type	Value
Quantity	39
Dollar	$540

Let me know with the possiblity. Thanks in advance.

PaulDBrown · ‎02-24-2020

@Anonymous

you can duplicate the measure and format each accordingly using the formatting options under "Measures tools" in the ribbon. Then use SWITCH to deliver the required output:

Measure format = SWITCH(TRUE(),

SELECTEDVALUE(table column [type]) = "Quantity", [number formatted measure],

[dollar formatted measure])

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

View solution in original post