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