Forum Discussion

Kaalu007's avatar
Kaalu007
Frequent Visitor
3 years ago
Solved

Column disappearing after scrolling preview window

Hi All,   I am working on sales data, for same i have few custom columns but while referncing same custom columns for creation of NEW CUSTOM COLUMN,        I FOUND few columns are disappeared ðŸ˜³.....
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Kaalu007 , Have you manually edited the code?

    In the advance editor, all steps should use the table you got in the previous step.

     

    In case you manually copy some code and added a new line, the chances that you skipped change of table name

Kaalu007's avatar
Kaalu007
Frequent Visitor
3 years ago

Good Morning Amit, 

Yes, as calculation logic is same for consecutive four(4) custom columns except ref. column.

so what i do, do copy from advance editor and paste in notepad 3 times, do few required change and finally do copy from Notepad to Advance Editor. But all of my columns are created bt this method only. i have only single table only, no relationship with other tables.

 

I have done all changes also tried with below solutions.

- entire copy pasted code to new blank query in new .pbix file (but problem was still there)

- removed red boxed custom column and fresh custom column created reference from choose from table 

 

what should i do now, please suggest.