Column disappearing after scrolling preview window

[Kaalu007]

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 😳....😵

So Around 152 custom columns, screenshot below for problem catched with details as.

Skyblue Box - Custom Columns

Red Box - Disappeared Columns

Orange Circled - New Custom Column where i need to refer Red Boxed Columns

Green Box & Arrows - where i found that required columns are disappered

Also, each red boxed columns has values in it.

Please help i am new with PBI, online courses does not teach such problems only forums and legends in forums are real teachers.

if required i can share few records of this data

PS : if you want to understand purpose of such data, it has 3 types of target.

Ori = Year Beginning Original Sales Target

Rev = Year Mid Revised Sales Target

Lst = Last Month Committed Sales Target

Now on every sales and after every sales, salesmen has to fullfil below 3 things

Sub = On Every Submission of Cibil Documents & commitment declaration by customer

1st = After sales 1st Installament commitment Date & Amount

2nd = After sales 2nd Installament commitment Date & Amount

3rd = After sales 3rd Installament commitment Date & Amount

i have to visualize all above table vs. below table condition.

Regards,

Tarun Verma

[Kaalu007]

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.   

[amitchandak · Accepted solution]

@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]

Yes, it saved my life, as it was only single and same table perhaps i tried with your solution.

 - Deleted all red boxed custom columns,

 - Choosen add custom column again

 - Edited formula in Notepad to avoid time writing formula

 - copy paste from notepad to pbi

Thanks again @amitchandak