Powerbi desktop

Hi  kemsie ,

If you want to remove your column in power query ; you can follow this procedure; 

right click column which you want to remove; select "remove column". 

if you want to remove column in the load section ( dax side), you can follow this path;

right click on column which you want to remove; then select "delete from model"; 

In order to add column in power query ( m side) ; you can directly write m language, or you can use nodes of pbi panel; 

choose "Add column " pane, then select "Custom column", then write formulation you want ;

If you add new column in dax side, its name is "calculated column", follow this path;

Select dataset-table ; click "Modelling section", then select "New column" then write formulation you want;

or right click on table and click "new column". 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

hi OguzMavice, many thanks for your response. The issue i am experiencing is not just removing a column, the current layout of the existing report has the following columns, trigger meant 1 = 3 months, trigger met 2 = 6 months, trigger met 3 = 9 months, trigger met 4 = 12 months. trigger met 5 = 15 months. The trigger met criteria has now changed, and i now need to replace my data source to remove trigger met 5 completely and also replaced trigger met 4 to 15 months. I have set this up in my data set source data, however, i am not sure on how to replace this on POWERBI without breaking the report.

I also have another issue which is seperate from the above, all our current reports that is designed as dataset and report is no longer showing as dataset, instead this now show as semantic model. And the reports are now showing errors with message that some colums does not exist in the rowset. This report has refreshed as expected all this time and no changes has been applied for it to break, the only pattern i can see has changed is the data set changed to semantic model. Please any idea how to fix this? and also to change the report back to data set setting? 

many thanks in advance.