How to convert a column of numbers into two different formats, one as whole num and one as currency?

[N7MESTE3]

Hi,

Is it possible to write a measure to return the pictured values as whole number and currency? I need any figure below 1000 to show as whole number and anything above that to show as currency. The data will be displayed in a table format.

Thank you!

[bhanu_gautam · Accepted solution]

@N7MESTE3 , You can create a measure like

FormattedValue =
VAR Value = SUM('YourTable'[YourColumn])
RETURN
IF(Value < 1000,
FORMAT(Value, "0"),
FORMAT(Value, "$#,##0"))