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, I have a calculated column to show
"OK" for matching values of column 1 and column 2
"NF" for missing column 2 values
(Column 1 - Column 2) for rest of rows . I am unable to format numbers. I need to show values like below example (highlighted in bold)
Example:
Column 1 Column 2 Calculated Column result
$1,000.00 $1,000.00 OK
$1,000.00 NF
$11,000.00 $9,000.00 $2,000.00
Solved! Go to Solution.
Hi @Anonymous,
The problem you are having is that the column/measure as two different type of values text and numbers in this case the measure is treated as text so the numbers will not have the correct format you need to setup a measure where you pass the format to the final result.
Try something like this:
Column = IF ( Table1[Column1] = Table1[Column2]; "OK"; IF ( Table1[Column1] = BLANK (); "NF"; IF ( Table1[Column2] = BLANK (); "NF"; FORMAT ( Table1[Column1] - Table1[Column2]; "$#,###.00" ) ) ) )
See result below:
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous,
The problem you are having is that the column/measure as two different type of values text and numbers in this case the measure is treated as text so the numbers will not have the correct format you need to setup a measure where you pass the format to the final result.
Try something like this:
Column = IF ( Table1[Column1] = Table1[Column2]; "OK"; IF ( Table1[Column1] = BLANK (); "NF"; IF ( Table1[Column2] = BLANK (); "NF"; FORMAT ( Table1[Column1] - Table1[Column2]; "$#,###.00" ) ) ) )
See result below:
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |