Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi everyone,
I have a simple table like:
Date | Day | Month | Year |
To filter Day, I could use = Table.SelectRows(Source, each ([Day] = "Monday")) for example. But I wonder if there is a way to filter the second column of the table instead of stating the column name?
I tried = Table.SelectRows(Source, each ([Table.ColumnNames(Source){2}] = "Monday")) but it didn't work.
Thank you.
Solved! Go to Solution.
Hi @Anonymous ,
you are on the right track with that approach. Just change it to:
Table.SelectRows(Source, each (Record.Field(_, Table.ColumnNames(Source){2}) = "Monday"))
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @Anonymous ,
you are on the right track with that approach. Just change it to:
Table.SelectRows(Source, each (Record.Field(_, Table.ColumnNames(Source){2}) = "Monday"))
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries