Forum

Hi Saiprasad, If you're using the code from this page, then it should work, the only change you need is to remove Application.Trim, as that is an e...

Hi Adam, You can use the same function that gets all dependents to build another recursive function that returns all precedents, then you can combi...

Hi Chris, Please prepare a clear example of what you are trying to achieve. Looking at your example does not clarify the problem, the first row sho...

Hi Adam, I think a recursive function is the best approach. Here is the GetOrg function: (Tbl,Org)=> let Source = Tbl, Filter=Table.Sele...

If you want to learn regular expressions, you can start here: They provide also a playground for JavaScript expressions, used in the power query fun...

This is the pattern I used: [A-Z]{2,3}\(?[A-Z]{1}\)?[0-9]{3}([A-Z]{1})?([0-9]{1})? File attached.

You can try this query. It's strictly based on your data, will list only teams where players are assigned. If the same team has 7 OF in the data, they...

Still not clear if those details will be set in Draft Result, or we have to setup the grid to have an exact number of OF, SP, RP and whatever is neede...

There is a way to use regular expressions to match complex patterns in power query, if you have messy data. Here is the function I am using: ...

The solution is in front of you 🙂 Select the Document column, replace "/" with a space, before using the Match function.

Your Match function needs a minor tweak, just add a space after the Document text: each Text.Contains(Text & " ",[Project])

ExcelNovice2020 said See attached updated file. Would the same procedure here hold true for the "Roster Grid?" As you can see, I have a ton of quer...

Basically, after we remove duplicates and we have a list of unique team names, you can click the merge button from pq editor, and merge the table with...

Ok, got the idea. See the attached file.

Hi, Something does not look ok: In grid example sheet, you have in B1 the Team name as header, then in round 1 (cell B2) for the first team you ...