Problem with RELATED function

[Anonymous]

Hello

I have two tables which I have joined them with a common column.

I put the common column in my dashboard table and now I want to put a second column from the second table next to it.

This second column has values Yes or No and no Blanks.

When I drag that column, the Yes/No are displayed next to the common column but in some instances, there are Blanks obviously because there is no value in the second column corresponding to the value in the common column.

How can I replace these blanks with 'New'?

I tried to use the related function but it says the table doesn't exist or there is no relationship.

Thanks

[amitchandak · Accepted solution]

@Anonymous , In march 2020 release you have support for coalesce

coalesce([Measure],"New")

[v-lionel-msft · Accepted solution]

Hi @amitchandak ,

As @amitchandak said, creating a measure:

coalesce(max( table[column] ),"New")

[amitchandak · Accepted solution]

@Anonymous , In march 2020 release you have support for coalesce

coalesce([Measure],"New")

[luapdoniv]

Please share a sample data set or screenshot of your tables, visual and table relationship