Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kan
Helper I
Helper I

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 cell   should be shown as blank only.How can i write this??

Qtrcalculatedcolumn need to be concatenated with Q
nullnull
1Q1
2Q2
3Q3
4Q4

 

Thanks

Swapna.

1 ACCEPTED SOLUTION
ChrisMendoza
Resident Rockstar
Resident Rockstar

@kan -

 

Try: 

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

6.PNG

 






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



View solution in original post

2 REPLIES 2
ChrisMendoza
Resident Rockstar
Resident Rockstar

@kan -

 

Try: 

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

6.PNG

 






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Thanks it worked for me..

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.