Column dissappears after adding it

Hi Anonymous ,

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.