Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

how to concatenate when column having null values

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 c...
Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    7 years ago

    Anonymous -

     

    Try: 

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

     

ChrisMendoza's avatar
ChrisMendoza
Resident Rockstar
7 years ago

Anonymous -

 

Try: 

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

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks it worked for me..