Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
I have a table with several columns (no surprise)
I would like to know if I can refer to column names by using a string, instead of a literal / raw reference.
I want to dynamically be able to choose what column I am using / referencing inside my measures.
So normally I would write
salesTable[nameOfColumn]
to reference a specific column.
However, I would like to do something like
VAR myColumnName = "columnOne"
//and then use that string variable inside the column reference:
salesTable[ myColumnName ] = 1
Is that possible?
or could I achieve the same thing by using quotes somehow?
like
"salesTable[myColumnName]" = 1
so that the whole expression is a string instead?
Please give me some tips and example code.
Thanks
@iplaygod unfortunately it is not possible but you can use if or switch conditions to refer to different columns.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 60 | |
| 47 | |
| 30 | |
| 25 | |
| 23 |
| User | Count |
|---|---|
| 141 | |
| 110 | |
| 65 | |
| 38 | |
| 33 |