The Magic of Records in Power Query || Display Advanced Calculations Step-by-Step

Join the waitlist for Power Query's M Language course↗️ - subscribepage.io/Learn_Power_...
In this video, we will learn how to use records in Power Query to expand the details of your calculations. With records, you can provide step-by-step explanations of how your calculation was built.
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File ⬇️ - goodly.co.in/explore-magic-of...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - [e-mail]
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[@GoodlyChandeep]

Download the File ⬇ - goodly.co.in/explore-magic-of-records/ Join the waitlist for Power Query's M Language course↗ - subscribepage.io/Learn_Power_Querys_M_Language

[@sujit3375]

Jab promo trailer itna acha hai toh movie kitni achi hogi.... All the best Chandeep for upcoming M code. Lots of love to goodly ❤

[@AnilKumar-lf5jt]

Okay now power query is becoming addictive thanks to you. Loving to use it as much as possible in regular work...

[@GoodlyChandeep]

Thanks Ani :)

[@shirshN]

Yes anil it is definitely fun n addictive. I spend more time on it than my actual test automation work 😁. I hope i could switch to this lovely thing PQ

[@AnilKumar-lf5jt]

@@shirshN instead of simply copy paste, I'm using PQ for every small thing 😂

[@kasondekasondel2885]

Thank you sir from Zimbabwe

[@RichardJones73]

You are truly a PQ genius

[@roywilson9580]

Great video. Very interesting use of records.

[@IvanCortinas_ES]

The best possible explanation of records. Very bright, as always. Thank you.

[@cristian.angyal]

Great idea Chandeep! 👏 Never thought of using records like this! 💡 Thank you for sharing this!

[@paspuggie48]

Very very smart way of working Goodly 😊

[@gabrielgordon]

Awesome! Thank you! good to learn also that you can have an if in the in statement!

[@rrrraaaacccc80]

Great 💯👍

[@prakharaug]

Nice way 👍🏻 will be helpful in some calculation in daily reporting

[@vinamrachandra9611]

So creative. Total is more than the sum of its parts. I love you videos.

[@MalinaC]

WOW! AWESOME!!!! 👏

[@MrVinayBN]

This technic is an eye opener for me and opens up lot of other possibilities. Thanks for sharing Chandeep!

[@Milhouse77BS]

Most excellent, sir

[@cherianiype]

very, VERY good Chandeep! bahut acha man! Thank you

[@arbazahmad7177]

Interesting 🎉.. thanks for sharing 😊

[@chrism9037]

Excellent!

[@malchicken]

Neat, thank you 😊 👌🏽.

[@martyc5674]

Brilliant!

[@inaction2024]

Interesting techniques.

[@sanumpzha]

Nice one as always.. 🤟

[@stretch233]

This is a great trick Chandeep, especially when building something new and validating the granularity of the data. Love it! 🔥

[@stefankirst3234]

Amazing! Besides the main topic of the video I´m thrilled to learn that you can have if-clauses in the in-statement. Thank you!

[@cristian.angyal]

⚠ Having a calculation (any calculation) in the in-statement will "hide" all the steps in the Query Pane

[@tug_van_tuggles]

Again some very interesting and useful knowledge. I work with teams who ask me for solutions, the teams are not always that good at saying what they want. I think I could use this to allow them to see which data in the calcuations are giving the true values and if they are working as they expect.

[@zahir585]

Brilliant ❤

[@bharathreddy4267]

Intresting....

[@Rice0987]

Dark theme with sunny shining bandana is super cool👏😁

[@tonydreisenstock]

Bloody brilliant. I also love the comment about using records for Add columns.

[@GoodlyChandeep]

Sharp observation but I have a few more tricks on column additions

[@arunkumarkesavan6077]

Super duber bro !!!

[@googlegoogle-gg3dp]

Zabardast.....love you

[@kebincui]

Awesome❤

[@williamarthur4801]

That was great, just the getting the record column as a true false could be so useful, have you thought about doing a video on what the MVP qualification covers, I think a lot of people would be interested unless MS have some rules regarding the matter.

[@shoaibrehman9988]

Brilliant

[@momosky9168]

Awsome 😮

[@andreaszucker]

Danke!

[@GoodlyChandeep]

Many Thanks!

[@grahamc5531]

Using records is also great for adding many columns in one step, then just expand the record to new columns. Reworked many a query where there have been multiple (sometimes > 10) #"Add Column" steps down to two steps - one for creating the record with each field (column) and one to expand the record to columns

[@larmondoflairallen4705]

How did you populate the values in the columns? I assume it wasn't a static value, so were you able to use a formula? I'm really interested how you did this.

[@grahamc5531]

@@larmondoflairallen4705 A table with two date columns named "Order Date" and "Due Date" - add two new columns calculating the age and an age bucket value. These steps need to be added via the Advanced Editor AddRecord = Table.AddColumn(Previous_Step_Name, "Record", each [ Days = Duration.Days([Due Date] - [Order Date]), Age Bucket = if Days > 14 then "Overdue" else "Current" ], type [ Days = Int64.Type, Age Bucket = text ] ), ExpandRecord = Table.ExpandRecordColumn(AddRecord, "Record", {"Days", "Age Bucket"} )

[@spen2431]

WOW !

[@mohitchaturvedi8931]

Unbelievable

[@2zibster]

Great tutorials, can you do a tutorial how to get date from current workbook, specific worksheet without creating a table?

[@josh_excel]

With the current workbook you can only input named ranges, so if you make the date a named range it can work. If you create a new workbook and link the previous workbook, you can then pull in the sheet you want even if there is no named range.

[@josecarlosconejo5724]

👏👏👏

[@emilmubarakshin49]

Chandeep you don’t stop amazing us with you brilliant ideas. Can I sign up for this course please?

[@GoodlyChandeep]

Yeah. Why not :)

[@AnilKumar-lf5jt]

Hi, need some help here. I have a source from share point. I need to filter out some data for which i use merge query, but I get a privacy issue error. How to deal with it? If i make a new query with the loaded data and merge it, no issue. But in this method, I'm unable to replace the existing data, so I'll be getting two tables, one full data and one filtered data. Can you guide me on how to approach this issue?

[@vidyashreeips]

@GoodlyChandeep Hi I need help. i am developing a dashboard for Collections efficiency. i facing challenge , i want a table to display the aging of currant month and last few months and this should be dynamic based on today's date. if today is 16 oct then column name should be October, if today is 15th oct then column name should be Sep 2023. i created a measure and new parameter for changing column names dynamically. but when i am using the filter options like show data for last 4 months, the table names are not changing. and new parameter created is not interactive with the slicer.. please help me to solve this..

[@abhidas7950]

Hi sir... could you please help me how to prepare a automated GST invoice series in power query for GST R-1 ... recently I am trying to do this but still I am not able. If you can any help, I will be grateful to you...

[@mithileshpawar132]

I have a question regarding merge queries. When I merge varies and expand the columns I am getting some columns as null. There is question mark at the data type icon. Can you please help me with same I am stuck from long time

[@sayyadabdulmugani8829]

Chandeep sir, Parvinder sir ko credit do, Same video create kiya hai aapne

[@PnumRithy]

I asked you my data on email, but you did not respond.

[@sajalsinghal8846]

Sir please give some discount on your course BI

[@Harish.Prasad.Semwal]

2:35

[@vidyashreeips]

@GoodlyChandeep Hi I need help. i am developing a dashboard for Collections efficiency. i facing challenge , i want a table to display the aging of currant month and last few months and this should be dynamic based on today's date. if today is 16 oct then column name should be October, if today is 15th oct then column name should be Sep 2023. i created a measure and new parameter for changing column names dynamically. but when i am using the filter options like show data for last 4 months, the table names are not changing. and new parameter created is not interactive with the slicer.. please help me to solve this..