topic Re: Concatenate if field if not null? in DAX Commands and Tips

Concatenate if field if not null?

Anonymous — Thu, 15 Apr 2021 22:52:08 GMT

I have a new column created using this formula:

Const Year-Quarter = CONCATENATE('Properties'[Const-Y]&"-", "Q"&'Properties'[Const-Q])

I would like to update this formula to concatenate If Const-Y is not null. If Const-Y is null, then return blank.

Lil help? 🙂

bongmw — Thu, 15 Apr 2021 23:00:11 GMT

Hi Anonymous

you can pretty easily have an IF statement within your CONCATENATE like:

Const Year-Quarter =
CONCATENATE (
IF ( NOT ISBLANK ( 'Properties'[Const-Y] ), 'Properties'[Const-Y] ) & "-",
"Q" & 'Properties'[Const-Q]
)

Anonymous — Fri, 16 Apr 2021 17:47:46 GMT

[Const Year-Quarter] = var Year_ = Properties[Const-Y] var Quarter_ = Properties[Const-Q] RETURN if( NOT ISBLANK( Year_ ), Year_ & "-Q" & Quarter_ )