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.
Good morning,
I created a calculated column in query editor ages ago, and i've realised that for some reason it's stopped working properly so I want to check what it's doing.
I want to view/edit the formula, but I don't know how to do this.
I'm in Query Editor, i've got the column highlighted, how do I edit?
Thanks!
Jemma
Solved! Go to Solution.
hi Jemma
in View ribbon you need the Query Settings pane enabled - it shows list of steps in currently selected query
you need to identify the step which added the column and click on the gear icon next to it - it will bring back the add column window, where you can edit
Hi @Anonymous,
Just double left cilck the step in the APPLIED STEPS field, then you can edit the formula.
Regards,
Frank
Hi @Anonymous,
Just double left cilck the step in the APPLIED STEPS field, then you can edit the formula.
Regards,
Frank
hi Jemma
in View ribbon you need the Query Settings pane enabled - it shows list of steps in currently selected query
you need to identify the step which added the column and click on the gear icon next to it - it will bring back the add column window, where you can edit
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |