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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
zlokesh
Resolver I
Resolver I

Column not reflecting in Edit Query

I added the new column in Power BI Desktop; but now when i am trying to edit the same thorugh Query Editor, its not reflecting.

I Tried Save, Apply and everything. Anything that i am missing, or any setting?

1 ACCEPTED SOLUTION
Stachu
Community Champion
Community Champion

Calculated columns are only available in the model (not in Power Query)
https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns

you need to create the column in Power Query to be able to transform it there
https://support.office.com/en-ie/article/add-a-column-from-an-example-power-query-cd82c570-8da7-4d70...



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

View solution in original post

1 REPLY 1
Stachu
Community Champion
Community Champion

Calculated columns are only available in the model (not in Power Query)
https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns

you need to create the column in Power Query to be able to transform it there
https://support.office.com/en-ie/article/add-a-column-from-an-example-power-query-cd82c570-8da7-4d70...



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.