Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Convert Line break values to Row without disturbing other columns value

Hi Superuser,   Could you please help on dealing line break values without disturbing other columns values Columns which has line break value are as below TRANSACTION OPPORTUNITY  TYPE OPPOR...
Need Help
Show and Tell
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    If you go to the step where the error is changed just click the cog weel and instead of null write the text you need.

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago
is possible to share PBIX file for reference
Please
MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

There was some errors within the new columns due to data inconsistencys.

 

Added a replace Error per each new column and everything working correctly now.

 

Check PBIX file attach.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    i encountered with data missing for some dates, 

     

    instade of replacing error with Null it is possible to use other value

     

    please help me/guide me

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    6 years ago

    Hi Anonymous ,

     

    If you go to the step where the error is changed just click the cog weel and instead of null write the text you need.