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

Подписаться 89 тыс.

Просмотров 22 тыс.

50% 1

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 - goodly.wordpress@gmail.com
===== 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!

Наука

Опубликовано:

29 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 62

@GoodlyChandeep 9 месяцев назад

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 9 месяцев назад

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 9 месяцев назад

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

@GoodlyChandeep 9 месяцев назад

Thanks Ani :)

@shirshN 9 месяцев назад

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 9 месяцев назад

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

@IvanCortinas_ES 8 месяцев назад

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

@stefankirst3234 9 месяцев назад

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 9 месяцев назад

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

@cristian.angyal 9 месяцев назад

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

@MrVinayBN 9 месяцев назад

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

@gabrielgordon 9 месяцев назад

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

@vinamrachandra9611 9 месяцев назад

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

@stretch233 7 месяцев назад

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

@cherianiype 9 месяцев назад

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

@roywilson9580 9 месяцев назад

Great video. Very interesting use of records.

@prakharaug 9 месяцев назад

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

@tug_van_tuggles 8 месяцев назад

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.

@RichardJones73 9 месяцев назад

You are truly a PQ genius

@kasondekasondel2885 9 месяцев назад

Thank you sir from Zimbabwe

@paspuggie48 9 месяцев назад

Very very smart way of working Goodly 😊

@tonydreisenstock 9 месяцев назад

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

@GoodlyChandeep 9 месяцев назад

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

@rrrraaaacccc80 9 месяцев назад

Great 💯👍

@MalinaC 9 месяцев назад

WOW! AWESOME!!!! 👏

@williamarthur4801 9 месяцев назад

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.

@arbazahmad7177 9 месяцев назад

Interesting 🎉.. thanks for sharing 😊

@grahamc5531 9 месяцев назад

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 9 месяцев назад

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 9 месяцев назад

@@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"} )

@Rice0987 9 месяцев назад

Dark theme with sunny shining bandana is super cool👏😁

@sanumpzha 9 месяцев назад

Nice one as always.. 🤟

@Milhouse77BS 9 месяцев назад

Most excellent, sir

@chrism9037 9 месяцев назад

Excellent!

@martyc5674 9 месяцев назад

Brilliant!

@malchicken 9 месяцев назад

Neat, thank you 😊 👌🏽.

@inaction2024 9 месяцев назад

Interesting techniques.

@zahir585 9 месяцев назад

Brilliant ❤

@kebincui 9 месяцев назад

Awesome❤

@momosky9168 9 месяцев назад

Awsome 😮

@arunkumarkesavan6077 9 месяцев назад

Super duber bro !!!

@bharathreddy4267 9 месяцев назад

Intresting....

@googlegoogle-gg3dp 9 месяцев назад

Zabardast.....love you

@shoaibrehman9988 9 месяцев назад

Brilliant

@spen2431 9 месяцев назад

WOW !

@2zibster 9 месяцев назад

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

@josh_excel 9 месяцев назад

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.

@emilmubarakshin49 9 месяцев назад

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

@GoodlyChandeep 9 месяцев назад

Yeah. Why not :)

@andreaszucker 8 месяцев назад

Danke!

@GoodlyChandeep 8 месяцев назад

Many Thanks!

@AnilKumar-lf5jt 9 месяцев назад

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?

@josecarlosconejo5724 9 месяцев назад

👏👏👏

@mohitchaturvedi8931 9 месяцев назад

Unbelievable

@vidyashreeips 8 месяцев назад

@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 9 месяцев назад

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 9 месяцев назад

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