Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi all,
I want to count the number of columns in a table, but excluding some columns with specific name.
This is what I have tried, but it's not working:
= Record.RemoveFields(Table.ColumnCount(#"MyTable"), {"ColumnX", "ColumnXP", "ColumnAAA", "ColumnVVBVV"} )
This bit of the M code is working fine:
= Table.ColumnCount(#"MyTable")
It returns 30, this is how many columns I have in the table.
However, I want to count all columns excluding the columns with these names - "ColumnX", "ColumnXP", "ColumnAAA", "ColumnVVBVV"
When I use the code I have pasted above, I get this error message:
As a workaround I have done the below:
= Table.ColumnCount(#"MyTable") - 4
and it's working
Since I know that I want to remove 4 columns I am just performing the subtraction.
However, I am keen on learning how to do this using M code.
Thanks,
Maria
Solved! Go to Solution.
Hey,
wow, I found a way as I kept playing with the code.
What I did is first, remove the columns that I don't want to count from the table:
= Table.RemoveColumns(#"MyTable"), {"ColumnX", "ColumnXP", "ColumnAAA", "ColumnVVBVV"} )
This M code returns a table. Then I have enwrapped this code in a Table.ColumnCount():
= Table.ColumnCount(
Table.RemoveColumns(#"MyTable"), {"ColumnX", "ColumnXP", "ColumnAAA", "ColumnVVBVV"} )
)
And I got exactly what I needed (:
I hope that this helps someone
Hey,
wow, I found a way as I kept playing with the code.
What I did is first, remove the columns that I don't want to count from the table:
= Table.RemoveColumns(#"MyTable"), {"ColumnX", "ColumnXP", "ColumnAAA", "ColumnVVBVV"} )
This M code returns a table. Then I have enwrapped this code in a Table.ColumnCount():
= Table.ColumnCount(
Table.RemoveColumns(#"MyTable"), {"ColumnX", "ColumnXP", "ColumnAAA", "ColumnVVBVV"} )
)
And I got exactly what I needed (:
I hope that this helps someone
Hi @mtomova, there are allways many ways:
= List.Count(List.Difference(Table.ColumnNames(#"Your Table Name"), {"ColumnX", "ColumnXP", "ColumnAAA", "ColumnVVBVV"}))
or
= Record.FieldCount(Record.RemoveFields(#"Your Table Name"{0}, {"ColumnX", "ColumnXP", "ColumnAAA", "ColumnVVBVV"}))
Hi,
thanks for providing different options!
Thanks,
Maria
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
10 | |
10 | |
8 | |
7 |