topic Re: Edit column data in Desktop

Edit column data

EVEAdmin — Fri, 21 Feb 2020 09:26:44 GMT

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.

Re: Edit column data

amitchandak — Fri, 21 Feb 2020 09:48:32 GMT

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

Re: Edit column data

EVEAdmin — Fri, 21 Feb 2020 09:54:17 GMT

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?

Re: Edit column data

Baskar — Fri, 21 Feb 2020 10:10:52 GMT

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/

Re: Edit column data

EVEAdmin — Fri, 21 Feb 2020 10:21:46 GMT

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?

Re: Edit column data

Baskar — Fri, 21 Feb 2020 10:29:45 GMT

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,

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/

Re: Edit column data

EVEAdmin — Fri, 21 Feb 2020 10:40:17 GMT

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.

Re: Edit column data

amitchandak — Fri, 21 Feb 2020 11:10:25 GMT

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

Re: Edit column data

Baskar — Fri, 21 Feb 2020 11:20:53 GMT

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/

Re: Edit column data

EVEAdmin — Fri, 21 Feb 2020 11:35:11 GMT

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

Re: Edit column data

EVEAdmin — Fri, 21 Feb 2020 11:36:50 GMT

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

Re: Edit column data

Baskar — Fri, 21 Feb 2020 11:38:55 GMT

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/

Re: Edit column data

EVEAdmin — Fri, 21 Feb 2020 11:47:27 GMT

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.

Re: Edit column data

Baskar — Fri, 21 Feb 2020 12:11:47 GMT

email dropped to your inbox. Please check.

Re: Edit column data

amitchandak — Sat, 22 Feb 2020 06:27:21 GMT

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

Re: Edit column data

EVEAdmin — Sat, 22 Feb 2020 06:32:31 GMT

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.

Re: Edit column data

amitchandak — Sat, 22 Feb 2020 06:39:29 GMT

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.

Re: Edit column data

ImkeF — Sat, 22 Feb 2020 08:40:07 GMT

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.