Forum Discussion

Phoebe_Zhang's avatar
Phoebe_Zhang
Helper I
6 years ago
Solved

how to edit cell value directly in query editor?

dear expert,

i have a column with year month value like'201912', i want to add a new column with the first date of year month with date format as result '12/01/2019".

i know we can add custmer column with formular, however, how can i type the value directly in cell like excel ? that when i direct input 12/01/2019 in the first cell then impact all the cells in column automaticly.

 

thank you.

Need Help
  • AnkitBI's avatar
    AnkitBI
    6 years ago

    Hi Phoebe_Zhang 

     

    Drag and extend formula to all cell is not possible with Power Query. What you can try is to use "Column from Example". It will automatically create formula required based on sample values. Keep in mind it will require 3-4 sample values to provide the expected result.

     

    Thanks
    Ankit Jain
    Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.

7 Replies

  • AnkitBI's avatar
    AnkitBI
    Solution Sage
    6 years ago

    Hi Phoebe_Zhang 

    Unlike Excel Power BI/Power Query works on complete Column. Once you create a Custom column , the formula will be applied to all the Cells of the base column instead of single cell.

     

    Hope I have answered your question.

     

    Thanks
    Ankit Jain
    Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.

     

    • Phoebe_Zhang's avatar
      Phoebe_Zhang
      Helper I
      6 years ago

      hi there,

      i want to type the value directly in cell itself instead of using formula, and after mannuall input two cells value in cloumn, all the additional cells change accordling with typing "Enter" button. which is same as working in excel,

      would you plese kindly advise? 

      • AnkitBI's avatar
        AnkitBI
        Solution Sage
        6 years ago

        Hi Phoebe_Zhang 

         

        Drag and extend formula to all cell is not possible with Power Query. What you can try is to use "Column from Example". It will automatically create formula required based on sample values. Keep in mind it will require 3-4 sample values to provide the expected result.

         

        Thanks
        Ankit Jain
        Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.