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
HansMostafavi's avatar
HansMostafavi
Icon for Advocate I rankAdvocate I
10 years ago

There is no drop down option for edit, you need to select the mesaure and use the formual bar to edit.

dpenny's avatar
dpenny
Icon for Helper II rankHelper II
9 years ago

Hans said "select the column" then edit in "formula bar."

 

I dont see any formula bar when I select a calc'd column in data view.

 

what is wrong?

  • 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