Last seen: Jun 25, 2026
@ld107 Fair enough, but can you upload a file with examples of say 25 parts for each asset and with duplicates? That would give you 125 items. And g...
@ld107 Not sure I follow what you want to achieve. Why have 10 columns that seem to be for 5 pairs of product (group) descriptions and part numbers?...
@southcoast73 To fix that issue, put the keyword Tesco last in the list of Tesco related categories. SEARCH is not case sensitive and will return an...
@pietc I actually find your solution very elegant. Would be interesting to see how both solutions perform on large data sets. R
@pietc Hi Piet, If this is still relevant for you, the attached file contains a simple PQ solution that does what you asked for. It suddenly occu...
@99yeg PP alone isn't really suitable for that. You could extend your data table in Excel and add some helper columns that determine the 'two-week b...
@pietc Fair enough, though my motto is to solve problems the easiest way. Often with PQ, but in this case it seems much easier with Excel formulas...
@pietc Must you use PQ? If you can live with a formula solution the modified names can be created with the following formula in your blue table. ...
@guillermo-besserer-ochoa Unfortunately the standard DAX documentation you find on-line is far from perfect and I would be the last to suggest that...
@guillermo-besserer-ochoa Please watch the tutorial in the link below. If that's not what you need, please upload your file.
@kpalaci15 The trick is to alter the "blue" CF rule by changing the first range of the "applies to" range to only one cell for a particular employe...
@cbird When you point a data validation (DV) list to a column of a structured table on the same sheet as where you create the drop-down it will work...
@chrisg Oh, if you are completely new to Power Query (PQ) and M (the code language that runs it), it may not be that easy. You need som basic knowl...
@chrisg How about the attached very basic Power Query solution? The result is very similar to what you described, but I believe it contains all yo...
@sjw Not Mynda here 🙂 As soon as you have entered the column name [Stock], the data options appear. Now enter a comma and the formula options wi...