Adding New measure

[SORPN]

1. Is it possible to add a new calculated measure (or) new calculated column to a table which is already published by me. If so anyone please let me know the procedure ?

2. Is it possible to view or edit the DAX measure when we Load data in power BI desktop from power BI dataset. ?

[pi_eye · Accepted solution]

Hi SORPN

1) You will need to export the .pbix (powerbi report file) that contains the data model, and edit that. 

The procedure, once you have the file opened locally is:

• Expand the fields list on the right hand side
• Right-click the table you wish to add the column / measure to
• Select either "'New Measure" or "New Column"

• Edit the expression using the formula bar above the report view:

• Once you are happy, save the file with the same name as the original and publish back to the workspace using the option under the file menu

• Ag

2) As far as I know, if you use PowerBI dataset that has already been created and on the service as your datasource

ie using this option: 

Then you cannot edit the dataset.

You will however, be able to edit the original using the steps outlined in 1)

I suggest you look into powerBI dataflows https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-ser... this might fit your situation better.

Many thanks,

Pi