Refer to a value, column or row in Power Query

Have you ever tried to use a specific column, row or value in power query, but didnt now how to do it?
In this video I will show you how to refer to a specific column, row or value using simple commands in power query.

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

ABOUT CURBAL:

************

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo

#SUBSCRIBE #CURBAL

[andyle]

This video along with "Create a table from values in Power Query #11" helped me unblock a problem that I was stuck on for hours. Thank you so much!

[juansepowerplatform]

Thank you, I been out for a while but came back for a very useful video. Thanks again

[marcelocabral]

i LOVE YOU Curbal, save my day tks :)

[marielito]

Gracias, Ruth. Este simple video era todo lo que necesitaba para resolver mi problema.

[Adr_C]

Can you do this for multiple records? Also, can you do it indirectly (eg a calculation returns the row number)?

[lucasfernandeslima]

Very valuable tip as always! Thank you very much!

[a.j.wilkes]

Thank you for the video! That drill down idea helped me to reference a date parameter so no more manual updating the datetime value.

[opod]

Thank you for the video! This helped me solved a problem that I was having, much appreciated.

[AzharKhan-ztxq]

Hey, I generate a monthly report, on the first row of which I get a date code- it is of format for e.g. 12107, will mean 2021, month July, 12008 will mean 2020 month August and so on. The amount of line or data would vary from month to month, how can I extract this in a year and month column ? Appreciate your help

[joannpaules]

Your video just helped me solve a problem I've been struggling with since yesterday. Thank you!

[sokgat]

Wow, didn't know that!!!! Thank you !!!!

[danielhuang]

I have a function to expand the columns dynamically:

= Rows1", "Data", Table.ColumnNames(#"Filtered Rows1"[Data]{0}))

My problem is I am currently using the column names in the table of the first row. I want to reference the last row (dynamically). Is this possible?

[pouyanebrahimi]

That was wonderful! Thanks! Please share more videos. i am planning to watch all of your videos :)

[sanc]

How to I use this value in other table is this possible?

[VastCNC]

Very interesting, I would love to see some examples of using this along with convert to table for some interesting data shaping tricks.

[sabinedanckers]

Hey Ruth, thanks for your video. I have been looking for a long time for a way to extract data from a field. And it's that simple! I really like such short films with a simple subject. I have not been busy with Power BI for very long and notice that I often search for YouTube videos on youtube! Thank you very much for your work! You do that well :)

[paulcooper]

Ruth, I love your videos.
I thought I might be able to reference a column and table and then invoke a function. So here's the problem. I have created a re-usable Calendar Table (thanks for that video). I reference the End Date from List.Max and refer to the Budget Table and [MonthEnd] to get the date. I also use List.Min to get the starting date from the transaction table [InvoiceDate]. I want users to be able to enter these as variables from my reusable calendar.
I have tried combining List.Max and Table.Column but when I turn it into a Function, it breaks with errors around the Date not being a text column.
I have tried various fixes and I am about to give up.
Do you have a video where the reusable Calendar can reference user-defined Table.Column which will then parse into formulas to get Start Date and Duration (these are formulas in the Calendar table already.

[rodrigorusche]

Hola Ruth, me preguntaba ... si podrías apoyarme como hacer la siguiente formula en power query =IF(A3=A4, "N", "Y") ... gracias !

[Magdoulin]

wait a minute, how you get this dark theme in the query editor? Please advise this should save my eyes :D

[PaweImioek]

Thanks, but in standard use cases you would have dynamic references to rows. It is really hard to find an explanation on the Internet how to achieve them.