Edit column data

[EVEAdmin]

Using the following measure

TABLE = DISTINCT(Table2[Column1])

I created a table with unique values from another table.

I now need to add a new column and edit data in the new column. 
Is that possible? Then, how?

Thank you. 

[Baskar]

Dear friend,

 Here i have give you three different way. Please pick which you need

1. Try to do all this kind of data manipulation in source sytem itself ( SQL, Oracle,Teradata ), if you have nature query support.

2. Try to achieve this via power query window. please find the below screenshor for reference.

3. We can do it in DAX, what you did. After creating a dax table you have to add column in the same screen , ref the attachement 

Conclusion :

       I would suggest you to go with action step 1. It will provide better performance than other steps.

Let me know if need more help on this. 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
http://powerbi.baskarbiconsultant.com/

[EVEAdmin]

@Baskar thank you

I need to create a "translation" table, where for each unique value I type the corresponding value.

Method 3 is what I need. I already created the column. The question is how do I manually edit the values in that new column?

[Baskar]

Friends, 

Manually we can't able to edit in this screen,

But you can acheive this with DAX switch statement. 

try this, 

SWITCH('Table'[Activity],

"a",1,

"b",2,

"c",3,

4)

Its for my understanding why you hvae to add manually ?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

http://powerbi.baskarbiconsultant.com/

[EVEAdmin]

@Baskar thank you.

As suspected, now I know I can't edit values manually. I need to edit values manually to reduce the 1000+ values, created from our customers, to a list of 10 values.

[Baskar]

No issues my friend, 

 we can do that by switch statement. why not try this instead of manual entry. 

let try this.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

http://powerbi.baskarbiconsultant.com/

[EVEAdmin]

@Baskar because using the SWITCH option, I need:

• write nearly 1000 lines for each current value
• update the lines each time because our customers may create new values

What I need is 1 table with 2 columns:

• 1 column = distinct values from a column in another table
• 1 column where I can edit values

[Baskar]

okay got it, 

Correct me if am wrong, it my understanding.

You have two table

1. Distinct value

2. Distinct column with your edited column ?

if yes, you can go with option 2, Power Query group by

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

http://powerbi.baskarbiconsultant.com/

[EVEAdmin]

@Baskar thank you.

GROUP BY will not work because it will create a new column in the source table. I need to have a new table with distinct values only from 1 column in the source table.

[amitchandak]

@EVEAdmin , is the issue resolved with the last solution provided.

[EVEAdmin]

many thanks for your follow up @amitchandak 

Whilst all the solutions suggested represent a good work around, it is clearly not possible to accomplish the task as reported in the first post. Thank you again for your help.

[amitchandak]

@EVEAdmin 

Thanks for the update. In case no more support needed. Mark the workaround, you think is best as a solution.

Enter data in Power is different stuff, Refer 

https://www.tutorialgateway.org/how-to-enter-data-into-power-bi/

I am not sure you can do enter data on the exiting the table.

@ImkeF , Please see if you can help.

[ImkeF]

You can create a lookup with manual entering of the data and then connect that to the data that you import.

But that means that you have to know the keys.

But it's not possible to first import data, load it into the data model, do a distinct with DAX there and then enter anything to it.

You can use the Power Apps custom visual to edit certain data sources from within Power BI. But that would edit the source data itself. So if you don't have a distinct there already, that might also not solve your problem.

[Baskar]

email dropped to your inbox. Please check.

[amitchandak]

If you working on data import mode. You should be able to do in excel and load here ?

[EVEAdmin]

@amitchandak thank you. I thought about that, however, the content is not static and I would need to update the excel sheet, each time.

All I need is 1 table with:

• 1 column = distinct values from a column in another table
• 1 column where I can type anything I want

[amitchandak]

In data view, try to add a new column on this table.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin

[EVEAdmin]

@amitchandak thank you

that is what I first did, however, I can't edit data in that new column. How do I edit values in that new column?