Forum Discussion
Edit column data
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.
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/
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
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/