Power BI & Power Query - Table Record Navigation vs Merging Queries

[@paulaparo1583]

Extremely clear and thorough. Highly valuable presentation. Thank you!

[@enriquedominguez9709]

Merging looks more powerful and friendly option. Great video!

[@OzduSoleilDATA]

Very cool! Merging a table with itself.

[@jazzista1967]

Excellent trick. I did not know that you could merge the same table with itself. Gracias Miguel!

[@ThePowerUser]

hey! thank you for watching the vid. Glad you enjoyed the vid! :)

[@kennethstephani692]

Great video!

[@GaribaldiInTheMaking]

Great trick to merge queries within the same query, thanks! If there isn't a simple "subtract 1" way to generate the new column (ie. two different texts), what is the best way then?

[@ThePowerUser]

Hey! Thanks for the kind words Working with integers or just basic numbers is probably the most optimal way to go. Is there any way to translate those text strings into some sort of ID numbers? are they actual numbers written in text or dates showing as text? You can transform a date in a text format to just a date data type and even when dealing with dates, you can get the previous year date or even the previous month with functions like Date.AddYears or Date.AddMonths - if you have any examples, I'd love to give it a try. Send me an email at [e-mail] with the table that you're dealing with and what the output should look like

[@GaribaldiInTheMaking]

Thanks for the reply. This is definitely the right thinking path for me. The thing is its not dates, its different item IDs in their respective stages of a manufacturing process. And not just 2, but sometimes several others. I'm trying analyze material variances at each level of a multi-level Build Of Materials (BOM). A sort of "where-used analysis" that compares a multi-level BOM with actual production costs...across many different production orders for the final product. We have an ERP system that does this in an unclear way, which is why I want to make a report that shows the variance piece by piece. It's a lot to throw on someone and several sensitive data sources make up this data, so I'll keep working on my own for now. I'm sure more knowledge of M code will come in handy here so I'll probably be purchasing your book soon. Thanks again!

[@ThePowerUser]

if you can simplify the scenario and create an example with just dummy data then I'm willing to look at it.

[@MuhammetMustafaAslan]

Thanks for sharing, It's very nicely prepared one.

[@ThePowerUser]

thanks! hope you enjoyed the video

[@CSalcedoDataBI]

Thank you, very good.

[@mchandrasekhar05]

You earned a subscriber..

[@gentle2005phir]

Liked it man

Great, thanks!

[@papachoudhary5482]

Thanks