Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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)?
Hi @Anonymous
Just click the option "Display the Formular Bar" in "Options and Settings".
Then you will see the Formular Bar in the Query Editor.
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 M function reference
Regards,
Xiaoxin Sheng
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
69 | |
54 | |
37 | |
35 |
User | Count |
---|---|
86 | |
68 | |
59 | |
51 | |
46 |