how to concatenate when column having null values

Question

Hi I have a quarter column Qtr&nbsp; in my report which shows as 1,2,3,4 but in my final report I need to show it as Q1,Q2.But it has null values&nbsp; ,so i cannot use concatenate function directly as blank cell&nbsp; &nbsp;should be shown as blank only.How can i write this??Qtrcalculatedcolumn need to be concatenated with Qnullnull1Q12Q23Q34Q4&nbsp;ThanksSwapna.

chrismendoza · Accepted Answer

Anonymous&nbsp;-&nbsp;Try:&nbsp;Concat = 
IF(
    (Table1[Qtr]),
    CONCATENATE("Q",Table1[Qtr])
)&nbsp;

Forum Discussion

how to concatenate when column having null values

2 Replies

Related content

Concatenate 3 columns

create custom column concatenated

Power query - concatenate text columns

Concatenate lists ;

Concatenate multiple columns to a single column

Qtr	calculatedcolumn need to be concatenated with Q
null	null
1	Q1
2	Q2
3	Q3
4	Q4