Use Measure column to replace text

Question

How to use Measure /column to replace text in another column using a calculation? I want to replace blank values in a column to a common group.

Answer 1

Hi Nithin,

For example, to replace null or blank values of postal code, I'm replacing the values using ISBLANK().

Create a column as below

Column  = IF(ISBLANK(Orders[Postal Code]),"NO Entry",Orders[Postal Code]).

Then the blank or null values would be replaced.

Hope it helps.