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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
antotom
Frequent Visitor

Dynamic referencing of a column

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?

1 ACCEPTED SOLUTION
jgordon11
Resolver II
Resolver II

try

 

= Table.SelectRows(#"Removed Other Columns", each Record.Field(_, LastCol) <> 0)

View solution in original post

2 REPLIES 2
jgordon11
Resolver II
Resolver II

try

 

= Table.SelectRows(#"Removed Other Columns", each Record.Field(_, LastCol) <> 0)

You got it, thanks a lot! 🙂

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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