Hi I have a PowerPivot with a calculated column that returns data via the RELATED function. The columns works perfectly except for a handful of rows that return an empty cell. After some troubleshooting I see that the cells that have blanks return FALSE to the ISTEXT function. What function can I use to convert my non-text values to text? I believe I need to use the FORMAT command but can't seem to find the correct format_string to apply to force the values to simple text. Let me know if you have any thoughts and thanks in advance everyone!

2 Answers 2


Try the DAX function ISBLANK() . Here is the DAX function ref: https://msdn.microsoft.com/en-us/library/ee634204.aspx


SharePoint is very loosly typed

 ="" & [NumberField]

Does a concatenation and returns a String

 =TEXT( [NumberField] )

Maybe works; it is usually used (with a second parameter) to format Dates and Numbers


  • Danny this is DAX not SharePoint :-)
    – MikeAinOz
    Commented Feb 28, 2016 at 5:49
  • All those MS products scripting/formula stuff are, more or less, based on VBscript Commented Feb 28, 2016 at 8:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.