Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello there,
I need to exclude the 0s from a column, but I have a problem referencing it.
Basically, I would need to exclude the 0s from Column “082022” (August 2022), and I'm doing it with this line of code:
= Table.SelectRows(#"Removed Other Columns", each ([202208] <> 0))
The problem is that the name of the column can change, it’s not always “082022”. In this regard, that name is coming from a previous step, in which I managed to retrieve the name of the last column in my data set, and I defined it as “LastCol”, with the following steps:
= Table.DemoteHeaders(Source)
= Table.Transpose(#"Demoted Headers")[Column1]
= List.LastN(#"Transposed Table", 4)
= #"Kept Bottom Items"{0}
The last step returned me indeed 082022, so my LastCol, but how can I reference it when I filter the column?
I tried using: = Table.SelectRows(#"Removed Other Columns", each (#"LastCol" <> 0))
But the filter doesn’t work, I don't get an error but the 0s are not filtered out.
Does anybody have any idea about how to do this please?
Solved! Go to Solution.
try
= Table.SelectRows(#"Removed Other Columns", each Record.Field(_, LastCol) <> 0)
try
= Table.SelectRows(#"Removed Other Columns", each Record.Field(_, LastCol) <> 0)
You got it, thanks a lot! 🙂
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
9 | |
7 | |
5 | |
5 | |
4 |
User | Count |
---|---|
10 | |
8 | |
7 | |
6 | |
6 |