Forum Discussion
Edit a Single Cell
Hello, I am trying to edit the data through Power BI Desktop. We have a lot of data that needs manually modified, but it seems the replace function does not work on a single cell. How would som...
Hi Anonymous ,
If you cannot modify the data in the query editor, you can only use DAX to create new columns as Greg_Deckler said.
Because there is no concept of cells in power Bi, you can only use DAX to create new columns, or use M query in query editor to modify the data.https://radacad.com/conditional-column-in-power-bi-using-power-query-you-can-do-anything
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Have you tried to replace it using Power Query ?