Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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ês