Forum Discussion
Edit column data
Friends,
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/
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.
If you working on data import mode. You should be able to do in excel and load here ?
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
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/
