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 :)
@shirsN
Жыл бұрын
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
Жыл бұрын
@@shirsN instead of simply copy paste, I'm using PQ for every small thing 😂
@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
@IvanCortinas_ES
11 ай бұрын
The best possible explanation of records. Very bright, as always. Thank you.
@MrVinayBN
Жыл бұрын
This technic is an eye opener for me and opens up lot of other possibilities. Thanks for sharing Chandeep!
@tug_van_tuggles
11 ай бұрын
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.
@vinamrachandra9611
Жыл бұрын
So creative. Total is more than the sum of its parts. I love you videos.
@cristian.angyal
Жыл бұрын
Great idea Chandeep! 👏 Never thought of using records like this! 💡 Thank you for sharing this!
@stretch233
10 ай бұрын
This is a great trick Chandeep, especially when building something new and validating the granularity of the data. Love it! 🔥
@RichardJones73
Жыл бұрын
You are truly a PQ genius
@kasondekasondel2885
Жыл бұрын
Thank you sir from Zimbabwe
@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
@cherianiype
Жыл бұрын
very, VERY good Chandeep! bahut acha man! Thank you
@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
@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.
@roywilson9580
Жыл бұрын
Great video. Very interesting use of records.
@Rice0987
Жыл бұрын
Dark theme with sunny shining bandana is super cool👏😁
@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"} )
@googlegoogle-gg3dp
Жыл бұрын
Zabardast.....love you
@Milhouse77BS
Жыл бұрын
Most excellent, sir
@MalinaC
Жыл бұрын
WOW! AWESOME!!!! 👏
@arbazahmad7177
Жыл бұрын
Interesting 🎉.. thanks for sharing 😊
@malchicken
Жыл бұрын
Neat, thank you 😊 👌🏽.
@bharathreddy4267
Жыл бұрын
Intresting....
@inaction2024
Жыл бұрын
Interesting techniques.
@arunkumarkesavan6077
Жыл бұрын
Super duber bro !!!
@martyc5674
Жыл бұрын
Brilliant!
@chrism9037
Жыл бұрын
Excellent!
@zahir585
Жыл бұрын
Brilliant ❤
@emilmubarakshin49
Жыл бұрын
Chandeep you don’t stop amazing us with you brilliant ideas. Can I sign up for this course please?
@GoodlyChandeep
Жыл бұрын
Yeah. Why not :)
@sanumpzha
Жыл бұрын
Nice one as always.. 🤟
@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.
@shoaibrehman9988
Жыл бұрын
Brilliant
@kebincui
Жыл бұрын
Awesome❤
@momosky9168
Жыл бұрын
Awsome 😮
@andreaszucker
11 ай бұрын
Danke!
@GoodlyChandeep
11 ай бұрын
Many Thanks!
@spen2431
Жыл бұрын
WOW !
@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
11 ай бұрын
@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..
@vidyashreeips
11 ай бұрын
@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..
@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
@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...
@josecarlosconejo5724
Жыл бұрын
👏👏👏
@mohitchaturvedi8931
Жыл бұрын
Unbelievable
@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.
Пікірлер: 62