Forum Discussion

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity 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

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