Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 someone suggest to manually modify data in Power Bi? All of this data comes from a source that cannot be modified prior to coming into Power BI. (Trying to automate a report).

I want for example for this data : 

 

 

to replace the empty cell in country by "UK" wen the ID=id2 and "FR" when the ID=id5.

Thank you for your help.

 

Best regards,

 
 
 
Need Help

3 Replies

  • camargos88's avatar
    camargos88
    Community Champion
    6 years ago

    Hi Anonymous ,

     

    Have you tried to replace it using Power Query ?

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    You could create a new column like:

     

    if [ID] = "id2" then "UK" else if [ID] = "id5" then "FR" else [country]

or in DAX

SWITCH([ID],
  "id2","UK",
  "id5","FR",
  [country]
)
  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago

    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.