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?
