Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I need to know how to remove total on the "Number Format" column
Solved! Go to Solution.
Finally its works with
Column = IF ( Table[Number] = INT ( Table[Number] ), FORMAT ( Table[Number], "#,#" ), FORMAT ( Table[Number], "#,0.00" ) )
much appreciate your reply
in my "number format " Column's options shown like this,
Hi.,
Check your data type in modeling tab for that particular coloumn. It should not be text . it should be a decimal.
Thanks
It's in Text Format because of this
Hai.,
Ignore my earlier post...this will work....
Number Format =
VAR X =
COUNTROWS ( VALUES ( 'Table'[Custom] ) )
RETURN
IF (
X > 1,
"",
IF (
SUM ( 'Table'[Number] ) = INT ( SUM ( 'Table'[Number] ) ),
FORMAT ( SUM ( 'Table'[Number] ), "#,#" ),
FORMAT ( SUM ( 'Table'[Number] ), "#,0.00" )
)
)
Finally its works with
Column = IF ( Table[Number] = INT ( Table[Number] ), FORMAT ( Table[Number], "#,#" ), FORMAT ( Table[Number], "#,0.00" ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |