Table Navigation Tricks in Power Query

[@GoodlyChandeep]

Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/

[@KuldeepSingh-nq1vi]

Hi Bro, I like your all videos and your way of expectation.kindly make a video on two statements. 1- Each keyword and 2- Underscore keyword in M Language.

[@cristian.angyal]

Knew about the ? returning a null (also working in "if" expressions) but never tried adding it to both Row number and Column name. Learned something new! Thanks for sharing Chandeep!

[@BIGorilla]

Chandeep, your videos just keep getting better. Hope you keep sharing as you're an invaluable source on KZbin. The question mark operator is a fun one, just like the coalesce one. Can't say I know many other program languages, but these operators feel special.

[@Juan-Hdez]

Very useful. Thank you.

[@GoodlyChandeep]

Glad it was useful!

[@Rice0987]

Thank you, Secret Boy.

[@IvanCortinas_ES]

Absolutely brilliant. Thank you very much!

[@GoodlyChandeep]

Glad you like it!

[@michaelangellotti5741]

Great video. I always learn something & you don't waste my time by making the videos longer than necessary. I don't need to watch them @ 1.5x speed like many tutorial creators. Keep up the good work & thanks.

[@GoodlyChandeep]

Awesome! Thank you!

[@ScottPerley]

Very well explained! Thank you!

[@GoodlyChandeep]

Glad you like it!

[@sanjeevsoni6793]

Excellent Golldy

[@GoodlyChandeep]

Thanks!

[@DK_85]

Thanks a lot. Explained very well understandable :)

[@GoodlyChandeep]

Glad it was helpful!

[@khaledabdel-rahman9748]

Great video, can i ask what application you use to draw on screen live ?

[@FRANKWHITE1996]

Great content. Thanks.

[@GoodlyChandeep]

My pleasure!

[@victor_wang_1]

Been using Power Query for a few years and never saw the ? trick. Thanks!

[@GoodlyChandeep]

Cool!

[@KishoreP-bu1bp]

Hi Bro, it was good, can you also let know if there is any way to automate the navigation if there an datasource is getting updated then the last table should load

[@kennethstephani692]

Great video!!

[@GoodlyChandeep]

Thanks!

[@KgasS]

Good one. searching for a solution to communicate to the user for any query failure in the form of a pop up (like message box in vba) for example if the data file is moved from a directory , the query file which refers to this data eventually fails on refresh. There may be API calls and yet to check

[@abdulrahmanbaamer8624]

Great video as usual... What if I want to navigate to one column only of the selected table, i.e. I only want column A... Thanks.

[@MelanieBreden]

I do it this way: = Excel.CurrentWorkbook()[[Name]]

[@abdulrahmanbaamer8624]

@@MelanieBreden thanks for your reply, I mean one column from the expanded table..I will try this as well...

[@MelanieBreden]

@@abdulrahmanbaamer8624 it works the same way, you have to reference exactly = Excel.CurrentWorkbook()[Content]{1}[[A]]

[@abdulrahmanbaamer8624]

@@MelanieBreden worked for appended query, thanks for your collaboration. I actually want to create a reference query, and get few columns from the original query; I did this: =#"original query name" {[[column1], [column2], [column3]]}. This returns an expression error: there is an unknown identifier. Did you use the [field] shorthand for a _[field] outside of an 'each' expression. Thanks again

[@MelanieBreden]

@@abdulrahmanbaamer8624 this returns a list: = #"original query name" [Column1] and this a table with one Column: = #"original query name" [ [Column1] ] this get several columns: = #"original query name" [ [Column1], [Column3] ]

[@singhbxut]

Good work

[@GoodlyChandeep]

Thanks!

[@garylhaas2005]

amazing stuff! i haven't watched it yet, but you would be good on the ESPN OCHO Excel challenge (ESPN 2 8/5 5:00 am 8/7 9:00 am 8/7 11:00 pm

[@ΠαναγιώτηςΧατζηαντωνίου-ι7θ]

Hi, great video. I would like to export a ms access query table with power query. The issue I am facing is that when I navigate in the table data, one specific column - in ms access short text - is converted to text automatically and for some reason I am losing dots in records. Is there anyway explicitly specify each column data type or just keep the dots...? (code used : = Source{[Name = "qry_GET_DB_for_Excel"]}[Data] ) Thanks in advance!

[@pravesh_ghanekar]

Hi sir, I created a table, using summarize function, but I have to work the table from other slicer, using selected values ​​function, but I tried a lot, but couldn't. Please help me in it

[@santoshpv321]

This is super...I have one question if you could assist. I have a source file that is downloaded but each time the sheet name changes - say Data15082022 if downloaded on 15/8 and Data16082022 if downloaded on 16/8. This causes query to break each time. How can this be fixed without editing query source each time? Thx

[@MarshaMinus100]

Hi Santosh, You can change your source to the folder, instead of the file itself, sort descending by Creation Date and only keep the top row. This will always give you the latest file. If you found another solution please share. I would love to know if there is a more efficient way to solve this.

[@swarnadipbandyopadhyay1727]

I am a beginner in Power BI. Just started working on DAX. I have a question regarding relationship. I have made four tables i.e. Sales, Products, Product Category, Product Sub Category. Found that relatable columns are automatically picked up. ProductKey column in Product table contains unique Product Key and that propagates Sales Table where Product Key gets repeated. The arrow direction is from Products table to Sales table. '1' is added to Products and a '*' is added to Sales. I think this type of relationship is called 'One to Many' but when I check the properties of the relationship it indicates as 'Many to one'. If tried to change to 'One to Many' it shows error statement. Please help me out of this problem. Thanks.

[@NMVJ]

Delete the Relationship and try again by activating, then dragging the column from Primary table to Secondary Table...It should work.

[@MrKirti333patel]

How to navigate table based on value inside any of the table and expand it? Like if any of the column of table x contains ‘Description’ then only expand this table

[@MelanieBreden]

with a few functions the code would look like this: = Table.SelectRows( Table.AddColumn( Excel.CurrentWorkbook(), "Check", each List.Contains(Table.ColumnNames([Content]), "Description") ), each ([Check] = true) )[Content]{0}?

[@JJ_TheGreat]

I don't get the second part... What is the purpose of putting a "?", as far as navigating goes - besides preventing an error? You are just going to instead force a null value. Where do you go from there? Thanks.

[@mayurshermale7220]

A big fan of you bro, how should I contact you