Microsoft Office Tutorials and References
In Depth Information
FIguRE 4-18 The color column contains empty values.
You cannot edit the data in the table to update the empty values with a fixed definition
because all data in a PowerPivot table is read-only. Nevertheless, you can easily add a
new calculated column that detects whether the Color column is empty and, in that case,
it returns our null description.
The formula for the new calculated column is the following:
= IF( ISBLANK( Product[Color] ), "<NO COLOR>", Product[Color] )
In Figure 4-19, you can see the new CalculatedColor column side by side with the original
FIguRE 4-19 The new calculated column replaced the empty values with <NO COLOR>.