Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Argument in AddColumn Function

= Table.AddColumn(
      #"Changed Type",
     "DoubleNumbers",
     each [Numbers] * 2
 )
 
I am wondering whether in this function, #"Changed Type"
is a table. Because the syntax of Table.AddColumn requires that the first argument is a table!
 
what am I missing?
1 ACCEPTED SOLUTION
artemus
Microsoft Employee
Microsoft Employee

In most cases each step in a query should be a table. In this case the #"Changed Type" refers to the result of the previous step, which is a table, not a function.

View solution in original post

2 REPLIES 2
artemus
Microsoft Employee
Microsoft Employee

In most cases each step in a query should be a table. In this case the #"Changed Type" refers to the result of the previous step, which is a table, not a function.

jbwtp
Memorable Member
Memorable Member

Hi @Anonymous,

 

This [the table] should be the case if you did not change anything manually, but can be anything (hard to say without seeing the entire query).

 

If you click on the Changed Type step in your query and see a table, this is a table.

Kind regards,

John

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors