Forum Discussion

aleon's avatar
aleon
Frequent Visitor
8 years ago
Solved

Create custom column

Hello,

 

On power bi desktop I have two colums whose vaule I take from a count(id):

I need to add another custom column with the next value: [REPO/(REPO+NOT_REPO)] * 100.

 

I can not add a new column on the table because the shoed values are the result of another operation and I don't have them on the table.

 

How can I add the custom column and work with the values displayed on the table?

 

Thanks!

 

  • aleon's avatar
    aleon
    8 years ago

    Dear all,

    Finally I could solve the problem, in stead of create a custom column I used a measure:

     

    Thank you everybody for your help and support

2 Replies

  • Hi aleon,

     

    From the data model it self we can create custom column 

     

    Edit Queris -->Under Add Column tab you have Custom Column from there you can write power query to get your result.

     

    If you get REPO and NOT_REPO as measures then you can directly crete another measure 

     

    First could you please explain how did you get REPO AND NOT_REPO so that i can givev you exact solutionn

    • aleon's avatar
      aleon
      Frequent Visitor

      Dear all,

      Finally I could solve the problem, in stead of create a custom column I used a measure:

       

      Thank you everybody for your help and support