Forum Discussion
Advocate IVCannot apply changes, if column is removed and a measure is using it - this worked before
Community SupportHi MiraNi ,
In the previous version, the use of dummy column is a bug, and it does not conform to normal operation. In the latest version, it is normal that an error will be reported when the deleted column is used in the created measure. If you create a new column to replace it, you must first ensure that the type of the field is consistent, otherwise an error will be reported.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Advocate IVHi,
I am not quite sure, what you are saying. But I know, that this current Power BI Desktop version, it is not working fluently. If I have a deleted column deleted in data source, so it is not available anymore and instead, a new column has been created for this purpose, there is no easy way to make this column change in DAX measure definition, if I am not able to apply these changes first to data model. As I have been able to do before. The error has been reported also before, you could see the error icon for these measures, that have been using the deleted column and then it has been easy to go and change the definition to use new column.
Now, if I am missing any column used in DAX code, I cannot apply the changes to data model meaning not to add a new column either to be able to use that instead. So the only way I know, is to create a dummy column with the same name as the deleted column was named. Then I am able to apply changes, make a definition change and then remove the dummy column. Much extra work, which was not needed before.
The error message is saying, that the column named xxxxx has been used and cannot be found anymore.
Rgds, Mira