how to concatenate when column having null values

[kan]

Hi I have a quarter column Qtr  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  ,so i cannot use concatenate function directly as blank cell   should be shown as blank only.How can i write this??

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

Thanks

Swapna.

[ChrisMendoza · Accepted solution]

@kan -

Try: 

Concat = 
IF(
    (Table1[Qtr]),
    CONCATENATE("Q",Table1[Qtr])
)

[kan]

Thanks it worked for me..