Forum Discussion

kfransis's avatar
kfransis
Regular Visitor
10 years ago

edit calculated or measure field

Hi,    I am just wondering if there's a way to edit calculated/measured field in PowerBI?   Thanks
BaldEagle's avatar
BaldEagle
New Member
9 years ago

Double-clicking on the field (in the field list) will bring up the formula bar

vanlyplh's avatar
vanlyplh
Frequent Visitor
9 years ago

I'm not seeing what you guys are seeing.  I double click on the filed and it just allows me to edit the name.  No foermula appears.  Surely this can be made a bit more intuitive.    Do I need to be in Modeling tab?  

  • P3Tom's avatar
    P3Tom
    Icon for Helper I rankHelper I
    9 years ago

    Inside of the data model, there are three types of fields (columns): native (which you can only re-name), calculated columns (you can single click on a calculated column and look immediately below the ribbon to see the formula bar) and measures (here, also, a single click on a measure will expose the formula bar below the ribbon).

     

    Hope that helps,

     

    Tom

    www.powerpivotpro.com

    • prbibuilder's avatar
      prbibuilder
      Regular Visitor
      7 years ago

      How's it going.

       

      This might be an old post, but I cannot edit a calcuated column as described in the above post.

      If I am in the "Data" view, with the fields on the right-side, when I double-click a calculated column,

      it gives me the ability to "Re-Name" the calculated column. If I click on a measure, the formula bar populates with

      the code to create that measure. However, when clicking on any calculated column, my formula bar is blank and shaded out.

       

      The only way I can edit or see what makes a calculated column, is to "Edit Queries", then find the line in the "Query Settings" for that table, where PowerBI recorded me creating the calculated column in the first place.

       

      I just updated my PowerBI tool to the latest version - 2.69.5467 64-Bit (May-2019)

       

      Let me know if this is a functionality that should be in the application and is not.

       

      Thanks,

      PR

      • charlie77's avatar
        charlie77
        Icon for Helper II rankHelper II
        6 years ago

        Yes, this is a weakness that needs to be improved. 

         

        The only way to see or edit the formula for a formulated column is in Advanced Query Editor.