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
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