Forum Discussion
Solved
Cannot create Calculated column in shared dataset
Hi all, I published a dataset to workspace to share with others, then find out shared users cannot create calculated column, only possible with measure. The goal is to let user have more autonomy i...
Hi, rdnguyen
If you have existing Power BI Premium Gen 2, Premium per capacity (PPC) or Premium Per User (PPU) workspace, you might consider creating a PowerBI datamart.
After you load the data into the datamart, you can model the data in the datamart such as creating relationships, creating mesures.
Best Regards,
Community Support Team _ Eason
Hi rdnguyen
Currently it is not possible for users to create calculated columns in the dataset, because for a calculated column the entire table needs to be reprocessed. Whilst when creating a measure it is only executed when it is put into a visual.
If you would want this to work please find the idea at https://ideas.powerbi.com
Thanks Gilbert, I will wait for the Datamart then 🙂