Forum Discussion
Post PatronEdit column data
Post PatronBaskar 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?
Resident RockstarFriends,
Manually we can't able to edit in this screen,
But you can acheive this with DAX switch statement.
try this,
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.
- amitchandak
Super User
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
- 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
