วีดีโอ

I have learned something new from this video. Thanks for sharing

Highly valuable ❤

Hi there, very good content as alwals, dou you have a collection of your work available to downnload, all together?

This is awesome. Thank you for sharing your knowledge.

Great example for Split Column. Thank you, Omid!

I need to substract sum tax column from first row in amount and the remaining substract it from second row and when result become negative put value in amount column

Thank you

Brilliant !

Thanks a lot, good and informative. I have a question though -- if one needs to do it on a large dataset, which option would give better performance -- large nested formula vs several simple steps? Thanks.

Excellent solutions Omid. Very well explained. Thank you very much!

Great video!! Great solution!! Alternative: - since had no data , if "m", date vect and "p" products vector =LET(t,LEFT(UNIQUE(p&MONTH(m))),g,GROUPBY(t,t,COUNTA,,0),FILTER(g,TAKE(g,,-1)=12))

good and easy explanation, thanks

Thank you

Excellent explanation, Omid. Thank you!!!

Translation not working with any way .. reason !!

Excellent solution. Thank you for sharing it, Omid.

Excellent 🎉🎉

❤

Grar 💯👍

💯👍

Great Omid!!! 💯👍

Find more solutions in Power Query, Excel, Python, and ...... here www.linkedin.com/feed/update/urn:li:activity:7173075223699812352/?updateEntityUrn=urn%3Ali%3Afs_updateV2%3A%28urn%3Ali%3Aactivity%3A7173075223699812352%2CFEED_DETAIL%2CEMPTY%2CDEFAULT%2Cfalse%29

Great video, Great smart challenge, like always, Great PQ solution.✌ - lambda alternative for any index hierarchy HPIV(h,v) Hierarchy Pivot where h: hierarchy indexes vector ; v: values vector =LAMBDA(h,v,LET(l,LEN(h),c,MAX(l),x,SORT(FILTER(h,l=c)),HSTACK(x,XLOOKUP(--LEFT(x,SEQUENCE(,c)),h,v))))

Thank you for your insights; they’re incredibly helpful! I tried finding the information you mentioned on LinkedIn, but I couldn’t locate it. If it’s easier, could you share the direct link here? That way, I won’t miss anything. Thanks so much for your help! 😊

Thankyou ❤

Great Solution! Below is my less advanced solution with Pivoted Columns, which I later filled down. To avoid hardcoded columns names {"Level 1", "Level 2", "Level 3"}, I extracted a list of all columns. let Source = Excel.CurrentWorkbook(){[Name="DataTable"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Code", type text}}), #"Add Level" = Table.AddColumn(#"Changed Type", "Level", each "Level " & Text.From(Text.Length([Code]))), #"Pivoted Column" = Table.Pivot(#"Add Level", List.Distinct(#"Add Level"[Level]), "Level", "Description"), ColNames = List.Select(Table.ColumnNames(#"Pivoted Column"), each Text.Contains(_, "Level")), #"Filled Down" = Table.FillDown(#"Pivoted Column",ColNames), #"Filtered Rows" = Table.SelectRows(#"Filled Down", each (Text.Length([Code]) = 3)) in #"Filtered Rows"

It seems so easy with your demo ! Thanks a lot.

Thank you for the great power query video.

@power-m-query: Your content is gold, but your speech is lacking. Is there any way you can use AI generated audio editing to clean and improve your voice? You would see different numbers in subscribers and views. (sorry, there is no private option in yt)

thanks

Link to the challenge file and other solutions on my LinkedIn page: www.linkedin.com/feed/update/urn:li:activity:7166573571031396352?updateEntityUrn=urn%3Ali%3Afs_updateV2%3A%28urn%3Ali%3Aactivity%3A7166573571031396352%2CFEED_DETAIL%2CEMPTY%2CDEFAULT%2Cfalse%29

Link to the challenge file and other solutions for this challenge: www.linkedin.com/posts/omid-motamedisedeh-74aba166_excelchallenge-powerquerychllenge-excel-activity-7160402770515128320-JLSU?

Perfect

Great video!! Great PQ solution!! For combinations without repetitions, (order not important) I always use the uniform distribution of random engine. A big enough random sample will hit all possible occurrences. CMB(n,c) : single formula lambda where n: number ; c: number chosen =LAMBDA(n,c,UNIQUE(SORT(MAP(SEQUENCE(20*COMBIN(n,c)),LAMBDA(x,TEXTJOIN(",",,SORT(TAKE(SORTBY(SEQUENCE(n),RANDARRAY(n)),c)))))))) Examples: =CMB(5,3) 1,2,3 1,2,4 1,2,5 1,3,4 1,3,5 1,4,5 2,3,4 2,3,5 2,4,5 3,4,5 The summing part is simple cosmetics. MAP(.....sum(index(v, textsplit... ✌

Sir, thanks for you video...could you please explain as how I can make possible combinations of 0331*******362...where * can be any number but interger should be fixed..... Appreciated your early response.. Please^3

Too hard to understand for me. ... Totally lost😢

Thanks Omid for showing that new (to me) technique of using the last argument to get the number of columns needed! I used this just yesterday and I couldn't figure out why it's not splitting into the columns I want, so I gave up, but thanks to you again. 👍💯

Thank you. 🥰

Another hidden gem. Thanks for sharing, Omid!

Super useful and never seen before. You're my super hero. Thanks a lot super Omid 🦸🏼‍♂️

Very useful, Thanks for the explanation

great as always

Thank you for the great power query video. I learn so much from the few vides you studied. Is it possible upload a file to follow along with?

Thanks.

Muy interesante Gracias por compartir

Super genius idea 😇

Amazing!!! What algorithm do you use for cluster classification (quartiles, percentiles, other...)? It would be nice to have something like this in Excel directly, without needing R. Thanks for the tutorial, Omid.

🥰thankyou Omid

I didn't know you before... Why ??? You're a pure genius to make me understand the Magic of power query. Lots of thanks

Excel with Python! Have no idea about Python. Will try it later. Thank you Omid for introducing that idea. 🙏