Forum Discussion
Adding New measure
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. ?
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-service, this might fit your situation better.
Many thanks,
Pi
1 Reply
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-service, this might fit your situation better.
Many thanks,
Pi