Forum Discussion

vanessafvg's avatar
vanessafvg
Community Champion
8 years ago
Solved

Table.Profile issue

Hi 

 

If i have errors in the data like #value or #n/a  then table.profile throws out errors, is there anyway of sorting out these issue without having to pre clean the data outside of excel?

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi vanessafvg,

     

    I think you can use Table.ReplaceValue to deal with these error values before use profile function.

     

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi vanessafvg,

     

    I think you can use Table.ReplaceValue to deal with these error values before use profile function.

     

    Regards,

    Xiaoxin Sheng