I’m glad that you found those links useful and it helped you.
So lastly, before we sign off from this thread here’s the answer to your question.
No, the measures and visuals won’t break at all if you make any changes into the Power Query either to “Table Name” or to the “Column Name” after writing your all the measures. They’ll just get updated automatically into your measures.
In order to prove my case, below are the screenshots provided for the reference alongwith the explanation -
- Old Table Name and Column Name into the Measure - In the screenshot, you’ll observe that “Table Name” is “Sales Data” and the “Column Name” within that table is “Total Order Quantity” and “Unit Price”.
- Changing the Table and Column Name - Now, I’ll go into the Power Query and change the “Table Name” from “Sales Data” to “Sales” and will also change the “Column Name” of “Total Order Quantity” to “Order Quantity”.
- Click on “Close and Apply” button and let’s check whether the formula get’s updated accordingly or not.
So in the above given screenshot, you’ll observe that changes made to the “Table Name” as well to the “Column Name” gets updated into the formula.
Conclusion: Any changes made into the Power Query i.e. whether editing the “Table Name” or “Column Name” (in this case). The formula will incorporate those changes without breaking any measures or visuals. But if we make these type of changes directly into the “Data Source” then the measures and visuals will break unless we incorporate those changes into the Power Query as well. (For this, I’ve already provided the links above, that if you face any such situation like this then how it can be sorted).
Hope you find this useful and meets your requirements that you’ve been looking for, for the question that you’ve asked.
Thanks and Warm Regards,