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
Mykhael's avatar
Mykhael
Icon for Kudo Kingpin rankKudo Kingpin
10 years ago

Hello kfransis,

 

What do you mean about "a way to edit calculated/measured fiel"? I need more information, Can you send me a screenshot about that? Please. That will be very helpful.

 

Best

kfransis's avatar
kfransis
Regular Visitor
10 years ago

Hi Mykhael,

 

Thanks for the response. 

 

So I added a new column called "11 week total" that is calculated based on the total of Week1+Week2+Week3+...+Week11 value. (see attached image) It works pretty well but then the next time when I want to update the calculation by adding/removing the column from that original formula, I can't seem to do that. The only option for me is either Rename, Delete or Hide. There's no option for edit.

 

Hope that clarify my question.

 

Thanks

 

 

  • Mykhael's avatar
    Mykhael
    Icon for Kudo Kingpin rankKudo Kingpin
    10 years ago

    I see, OK dont worry, I will help you.

  • Mykhael's avatar
    Mykhael
    Icon for Kudo Kingpin rankKudo Kingpin
    10 years ago

    You should see something like this (three dots) in the right area, once you click on those, a menu will be displayed, over there you can select DELETE. If doesnt work I strongly recommend you to reinstall Power BI desktop, maybe is out of date. Let me know if it works please.

     

    Best

     

    • kfransis's avatar
      kfransis
      Regular Visitor
      10 years ago

      Mykhael,

       

      Thanks for the quick response. Having said that, I am not trying to delete the custom column. What I am trying to do is to edit them.

       

      Kamiel

       

       

      • Mykhael's avatar
        Mykhael
        Icon for Kudo Kingpin rankKudo Kingpin
        10 years ago

        Hello kfransis

         

        I am sorry about the misunderstanding. I share this screenshot, as you can see it's very easy. But If this doesnt work for you, let me know, I will help you on that, I promise.

        Best