Added Measure in Pivot - Add text if field is blank

Super Contributor

Hello, how could I populate the field with N/A if it is blank? 

 

thank you

 

=CONCATENATEX( Table2, Table2[Balance Rolled To Date] )

Tony2021_0-1644850523902.png

 

1 Reply

@Tony2021 

It could be measure like

myMeasure:=VAR something=SUM(Table[Field]) // whatever
RETURN IF( ISBLANK(something), "N/A", something )