How to replace blank value with NA in calculated column measure?

[Kiranbc]

Hi ALl,

Below is the calculated column but there are lot of blanks which is expected, but I want to replace with NA. Please help

client names = MAxx(filter(Client, Client[Project Number] = Utilization[Project Code]), Client[Client Name])

[Samarth_18]

Hi @Kiranbc ,

You could try this:-

client names =
VAR result =
    MAXX (
        FILTER ( Client, Client[Project Number] = Utilization[Project Code] ),
        Client[Client Name]
    )
RETURN
    IF ( OR ( ISBLANK ( result ), result = BLANK () ), "NA", result )

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but please try the below whether it suits your requirement.

client names =
COALESCE (
    MAXX (
        FILTER ( Client, Client[Project Number] = Utilization[Project Code] ),
        Client[Client Name]
    ),
    "NA"
)

[Kiranbc]

It worked like charrm. Thanks for quick resolution!.