Download the file ⬇ - goodly.co.in/advanced-unpivoting-tricks-power-query
@dr.vaibhavhase5979
25 күн бұрын
❤❤
@RogerStocker
25 күн бұрын
Hey Chandeep you are teaching like a hurricane. I really enjoy every second. None can be better for M language, I'm convinced.
@emanuelecostantinocatanzar3042
Күн бұрын
Hey, Chandeep, I love your way of teaching. First of all, you explain the logic behind the problem and then you also get fun in fixing the issue. Everything seems so easy 🙂 Your knowledge of the matter is outstanding. Great great job, man!
@mikizhero
7 күн бұрын
I really like to know the M language, but you are too fast for me. I am in awe of your mastery of M language. Honestly, there was a time I was stuck in my work, I searched Google and KZitem, I couldn't find any solution except for your video of creating a total row for a table of columns. That was life-saving. Thank you Chandeep
@vacilando86
25 күн бұрын
You are the big boss of PQ, respect
@enocharthur4322
25 күн бұрын
This is incredible. I check out your master m language course it's very expensive. Kindly reduce the cost a lot
@danielhervert3629
24 күн бұрын
😂
@ginesc
24 күн бұрын
🤣 I need a new car .. I´m gonna use similar technique maybe it ´ll work !!!! tks you !!!
@elmzlan
16 күн бұрын
Its worth it though.
@TopBam
18 күн бұрын
Chandeep, you've not only helped learn power query, but you've taught me some really important coding skills too!
@neelguru6562
25 күн бұрын
Sir when you are going to lunch your book of M CODE language. I'm your biggest fan. Your way of teaching is excellent ❤❤❤
@KleanthisSkoulikaris
24 күн бұрын
Oh man, watching you keep adding to the first M code formula instead of using multiple steps reminded of Matt Damon talking about Jack Nicholson in the movie "Departed".... "Now, you COULD end the scene there, but if you keep the camera rolling...." 😁😁😁. You're like the gift that keeps on giving!
@baskis69
11 күн бұрын
Incredible, pure magic {M}.... Masterfully explained .... thanks for sharing!
@Softwaretrain
25 күн бұрын
This is an excellent example of utilizing the advanced unpivoting technique. Thank you for the fantastic video and explanation! I’ve attempted to solve these three examples using a different method, which may provide your audience with an alternative solution, as outlined below. Example1: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], Custom1 = Table.Combine(List.Transform(Table.Split(Source,3),each Table.PromoteHeaders(Table.Transpose(_)))) in Custom1 Example2: let Source = Excel.CurrentWorkbook(){[Name="Dataset"]}[Content], split = Table.SplitAt(Source,2), Header = List.Transform(Table.ToRows(Table.FillDown(Table.Transpose(split{0}),{"Column1"})),each Text.Combine(_,"|")), AddHeader = Table.RenameColumns(split{1},List.Zip({Table.ColumnNames(split{1}),Header})), Unpivot = Table.UnpivotOtherColumns(AddHeader,{"Bz"},"Header","Value"), SplitColumnbyDelimiter = Table.SplitColumn(Unpivot, "Header", Splitter.SplitTextByDelimiter("|", QuoteStyle.None), {"Company", "Dept"}), ChangedType = Table.TransformColumnTypes(SplitColumnbyDelimiter,{{"Bz", type text}, {"Company", type text}, {"Dept", type text}, {"Value", Int64.Type}}) in ChangedType Example3: let Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content], Custom1 = Table.Combine(List.Transform(List.Split(Table.ToColumns(Source),3),each [a=Table.FromColumns(_), b=Table.PromoteHeaders(Table.Skip(a,1)), c=Table.AddColumn(b,"Country",each a{0}[Column1]) ][c] )) in Custom1
@chrism9037
25 күн бұрын
So amazing Chandeep!!! Thank you
@samitube007
25 күн бұрын
I'm facing a real challenge right now, and this video came at the perfect time. Highly appreciated
@freipfeifenprospekt
21 күн бұрын
Whow. Apart from the excellent content - where did you learn to teach so well?
@danishnawaz3651
22 күн бұрын
Stunning Sir. Plz do more videos.
@businessinsights_AlexRobe
22 күн бұрын
This is magic! So efficient and compact - love it! 👌🙏
@carolshipley7903
24 күн бұрын
This is brilliant Chandeep. Just what was needed for the problem I sent you. Thank you very much.
@StephenDagg
25 күн бұрын
Thanks so much Chandeep, these tutorials are fantastic. Keep 'em coming!
@ursvenky6394
24 күн бұрын
Wonderful video. I recently struggling with second problem. I got the solution by you. Thanks Chandeep
@bendreessen2809
24 күн бұрын
Amazing! you provided the exact solution I needed! thank you so much for all of your help and easy to understand teaching style!!
@thierrysouchard471
16 күн бұрын
Awesome! as always.Thank you
@deda118
8 күн бұрын
Great explanation. Can you show a power BI statement month by month with the months as column headers? It’s typically how data is presented.
@kennethstephani692
24 күн бұрын
Another awesome video!!
@odallamico
24 күн бұрын
Great tricks. Thanks for sharing
@catherinegould6662
20 күн бұрын
Amazing - that logic is awesome. Lists are scary cool
@williamarthur4801
25 күн бұрын
Great video, I know it 's not that practical but for fill up down, I used let f = { Table.FillUp, Table.FillDown} in List.Accumulate ( {0..1}, Table.Transpose(Custom1), (s,c)=> Function.Invoke( f {c} , { s, Table.ColumnNames( s ) } ) ) , oh great use to combine columns.
@SathishKumar-oq7tz
23 күн бұрын
It's just amazing tricks, thank you Chandeep for sharing with us.
@basheert8848
24 күн бұрын
Nice one I subscribed because of this video 🎉 keep it up ❤
@Luciano_mp
23 күн бұрын
Wow, brilliant! Congratulations! Thank you.
@donniemcgee7523
22 күн бұрын
Thank you for this excellent presentation. It is extremely helpful.
@-seesi-
25 күн бұрын
Hey Chandeep! In your third example you hardcoded the 3 (25:00). You could wrap the SecRecordAsHeaderList step into List.Count, so you get the number of the cols!
@raimundojs9547
24 күн бұрын
Fantastic! Awesome!
@krishna6296
23 күн бұрын
Thank you for the detailed video on ower query editor data transformation.
@ahmedoufkir8235
15 күн бұрын
Amazing, Thanks a lot
@dirkstaszak4838
4 күн бұрын
Bloody awesome thanks
@williamarthur4801
10 сағат бұрын
as an alternative to adding an index try zip; = List.Transform( List.Zip( { ListOfTables, {"Engalnd","India"} } ), (x)=> Table.FromRows( {x} ) ) then table combine .
@sanjeevsoni6793
25 күн бұрын
Great tricks 🎉
@alterchannel2501
3 күн бұрын
Wow incredible❤
@Klick213
23 күн бұрын
A masterpiece!
@prashantpavar8303
25 күн бұрын
This is awesome
@shubhabratadey
17 күн бұрын
I wonder whether you speak with HUMANS in M language or not... 😁 Simply Superb
@arbazahmad7177
25 күн бұрын
Excellent... thanks for sharing 🎉
@chrismiles7040
25 күн бұрын
@GoodlyChandeep is your book going to be available digitally on the Google Books store or do we have to buy a hard copy?
@ashivns
25 күн бұрын
Thanks 🙏 eagerly waiting for your video
@sharmarudra
24 күн бұрын
I love his teachings. Can anyone fund his courses for me, please ?
@mogarrett3045
25 күн бұрын
my brotha Goodly I get this crap all the time....makes me wanna open up 'a can of woop ass' . pisses me off to no end. Clients have no passion for their data. thank you for sharing. Power Query is the magic in the data kitchen. thanks brotha for your insight as always
@SalmanHussain94
25 күн бұрын
You are just Amazing!
@storieswithtarasharma2914
22 күн бұрын
Remember these all function is little complicated so I hope you will tell us the way by which we can apply logic in real time data problems because every time we have a different situation
@kamil4177
22 күн бұрын
Hi, in 20:41 you're refering to row as a column;) but I get the idea;)
@pk231
23 күн бұрын
I don't know why your video is like ASMR to me😅. 30 mins went just like that
@mayurnarayan1
20 күн бұрын
This person is a wizard😅
@djl8710
25 күн бұрын
Good Stuff Goodly!
@mogarrett3045
25 күн бұрын
Thanks brotha
@justjerry7844
25 күн бұрын
Pretty darn awesome 👍👏👏👏
@rinaldobranquinho
19 күн бұрын
00:24 Example 1 06:50 Example 2 18:28 Example 3
@RichardJones73
25 күн бұрын
You make power query seem so damn easy
@Tuhin380
25 күн бұрын
Just awesome❤❤
@user-dc4rs4mr2b
8 күн бұрын
Suppose in the table consist few column null value and in excel two table between empty two columns how can we handle that
@mrbartuss1
23 күн бұрын
I've noticed that you prefer to put everything into one step. Is it more efficient or something? Why not doing it in separate steps?
@azizquazi
17 күн бұрын
Can we not do everything using UI?
@mnowako
25 күн бұрын
Thanks
@GoodlyChandeep
25 күн бұрын
Thank you so much!
@AlishaPathan-o3r
3 күн бұрын
How to share powerquery data file or mail to someone, please share
@williamarthur4801
23 күн бұрын
Third time of watching, I must get out more. 🙄🙄
@kumaraswamyreddy2144
24 күн бұрын
Any discount for your 3 course bundle
@kumaraswamyreddy2144
24 күн бұрын
If i took the course Mastering Dax, will i get all the video's at a time or its like adding videos weekly?
@GoodlyChandeep
24 күн бұрын
you'll get all the videos. please drop me a note on chandeep@goodly.co.in
@tempmail5660
22 күн бұрын
hey goodly I’m looking to enroll myself in dax course of yours can you please tell me if there is a doubt session. Can we communicate our doubt to you.
@GoodlyChandeep
22 күн бұрын
All students leave comments or post their questions in the community. I hope that helps 😀
Пікірлер: 77