How to avoid using "hard coded" column names in my M code?

[eurenergy]

Hi all,

I recently spoke with a consultant who is very proficient in using Power BI. He mentioned that his #1 rule was to avoide using hard coded column names in his M code. I understand what he means as Power BI is very sensitive when it concerns column names.

But how can this be a #1 rule when I think its best to use column names when doing something as simple as changing the data types? You have to adjust data types at some point and by doing that you already have hard coded column names in your M code.

Kind regards,

[Anonymous]

Hi @eurenergy ,

You can replace hard-coded column references with dynamic references.

For more detailed information, please refer to the following links:

Solved: Replace hard coded column reference with dynamic r... - Microsoft Fabric Community

How to Handle Dynamic Columns using M query in Power BI | by Datasciencedaemon | Medium

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.