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.

     

     

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

Hi Anonymous ,

 

Before making the new column do not make any changes in the type of data, check if there is  a step where the format of the data is changed and delete that step.

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.