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!
@N7MESTE3 , You can create a measure like
FormattedValue =
VAR Value = SUM('YourTable'[YourColumn])
RETURN
IF(Value < 1000,
FORMAT(Value, "0"),
FORMAT(Value, "$#,##0"))
Proud to be a Super User! | 
|
@N7MESTE3 , You can create a measure like
FormattedValue =
VAR Value = SUM('YourTable'[YourColumn])
RETURN
IF(Value < 1000,
FORMAT(Value, "0"),
FORMAT(Value, "$#,##0"))
Proud to be a Super User! |
|
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
