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!


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

| improve this answer | |

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


| improve this answer | |
  • Danny this is DAX not SharePoint :-) – MikeAinOz Feb 28 '16 at 5:49
  • All those MS products scripting/formula stuff are, more or less, based on VBscript – Danny '365CSI' Engelman Feb 28 '16 at 8:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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