not null
1 TopicConcatenate if field if not null?
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? 🙂1.8KViews0likes2Comments