Column dissappears after adding it

[John_Doe3]

Greetings, 

I try to add a column to my sheets in Power BI. I right click on my table/sheet and select "new column". It appears at the end of my table, but when I click on it, the small "applying changes" windows appears and.... Poof, gone is the column.

Besides being incredibly frustrating, what could be the use of the function "new column" when it doesn't actually add a new column? Am I doing something wrong? Or was frustration the only goal of this function and is it just working as intended?

Thanks in advance

[v-venuppu]

Hi @John_Doe3 ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.

Thank you.

[v-venuppu]

Hi @John_Doe3 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-venuppu]

Hi @John_Doe3 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-venuppu · Accepted solution]

Hi @John_Doe3 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @saritasw for the prompt response.

When you add a New Column using DAX in the Data or Report view, it's added to the data model, not to Power Query (Transform Data).

Power Query (Transform Data) doesn't "see" columns created with DAX, because it's a separate step that happens before the model is built.

 If you want the column in Power Query (Transform Data):
Go to Home > Transform Data

In the Power Query Editor, right-click your table and choose Add Column from there (like "Custom Column")

This will keep the column in Power Query - and you can modify it before loading to the model

 If you're using DAX New Column:
It's normal that it doesn't show up in Power Query

You can use it in visuals and calculations, just not in the Transform step

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

 

[John_Doe3]

Hi saritasw, 

Thank you for your time.

I have tried saving and reloading several times, but to no avail. I did manage to get the column "to stay" by removing the formula start and checking the green checkmark. So I do have a column now. However, when I go to transform to get a value inside this column, the column isn't present at all (in power query). Tried saving and loading in different manners, but to no avail.

[saritasw]

@John_Doe3 .
That's rare, but Power BI Desktop occasionally glitches. A column might not show up until after restarting the app or refreshing the model.

Save your file and restart Power BI Desktop, and see if the column reappears.
_______________________________________________________________________________________________________________________

f this solution worked for you, kindly mark it as Accept as Solution. This would be helpful for other members who may encounter similar issues and feel free to give a Kudos, it would be much appreciated!
Thanks,

Sarita