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 Experts.
I have the following dax measure which kind of gives me the right answer..
%= if(left(trim(firstnonblank (grp[ReportHeaders], "")),1)="%",
Format (([measure] /100, "##0.0%;(##0.0%);-"),
Format (([measure], "##0.0;(##0.0);-")
)
Which converts value -1,800.0 to (1800.0) missing out the comma for thousands and like wide for positive values too.
How do I amend.
Solved! Go to Solution.
@Anonymous , not tested try if this can work
%= if(left(trim(firstnonblank (grp[ReportHeaders], "")),1)="%",
Format (([measure] /100, "#,##0.0%;(#,##0.0%);-"),
Format (([measure], "#,##0.0;(#,##0.0);-")
)
@Anonymous , not tested try if this can work
%= if(left(trim(firstnonblank (grp[ReportHeaders], "")),1)="%",
Format (([measure] /100, "#,##0.0%;(#,##0.0%);-"),
Format (([measure], "#,##0.0;(#,##0.0);-")
)
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |