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 possible? Then, how?
Thank you.
17 Replies
In data view, try to add a new column on this table.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedinamitchandak thank you
that is what I first did, however, I can't edit data in that new column. How do I edit values in that new column?
Dear 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/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/
