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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

How to view or change a formula on an existing custom column

Hi, if i create a custom column with a formula, how do i view and update the formula after it has been created (in the query editor)?

3 REPLIES 3
Anonymous
Not applicable

Hi @Anonymous

Just click the option "Display the Formular Bar" in "Options and Settings". grafik.png

 

 

Then you will see the Formular Bar in the Query Editor.

grafik.png

 

Anonymous
Not applicable

This shows the formula for the most recently applied step to the query. It doesn't show the formula that was used in a currently selected calculated column. It seems that if i wanted to figure out what formulas someone has applied to a column the only way i can do it is to go back through the history of applied steps as you implied above, and view the formulas or statements that were used to create those columns, until i find the right one. Also, while that might tell me what was used when the column was created how can i change it? Do i have to delete and re-add a column to achieve that?

Hi @Anonymous,

 

>>Do i have to delete and re-add a column to achieve that?

No, you not need to re-add it, you can open the advanced editor to see the full form of it, then you can modify it on formula bar or advanced editor.

 

Reference link:

Power Query 101

Power Query M function reference

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.