Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
iplaygod
Resolver I
Resolver I

DAX: Refer to column using string or similar

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

1 REPLY 1
parry2k
Super User
Super User

@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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors