Why it displays TABLE in custom added column in Power Query?

[alipezu]

Hey All,

It displays "Table" in custom added columns.
I click on TABLE in custom column and it adds extra unwanted step in APPLIED STEPS field which I don't want.
Please help me solve this issue.
here is a screenshot: https://drive.google.com/file/d/0B9uKuwzDH_rQYWZqMUtZSnE4LTA/view?usp=sharing

Thanks.

 

[Comfy]

You've nested a Table.AddColumn within a Table.AddColumn

Change this:

= Table.AddColumn(#Unpivoted Columns", "Custom", each Table.AddColumn(#Unpivoted Columns", "Custom", each if Text.Contains([Attribute], "Students") then [Value] else null))

To this:

=Table.AddColumn(#Unpivoted Columns", "Custom", each if Text.Contains([Attribute], "Students") then [Value] else null)

Additionally, while screen shots are a great help, posting your source data and M make it easier for us to replicate and fix any issues.

 

[alipezu]

I sorted it out.. Thanks alot!