Forum Discussion
Post PatronEdit column data
Resident RockstarDear 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/
- EVEAdmin
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?
- Baskar
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,4)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/
