Last seen: Jul 8, 2026
Ah, I see. Other than a small filter error my method doesn't seem to work. don't really have a solution for that at the moment. Perhaps later,
See if the attached PQ solution works for you. I didn't make it pretty or very advanced. And it requires quite a bit of merging, duplicating, sorting ...
Hi again, I answered before I saw your posting nr 4, but believe is covers your requirement.
Perhaps like in the attached file?
Hi Preston, First of all I suggest you read Mynda's blog on absolute references within structured tables. Excel table absolute structured refere...
Since you posted your question in the Power Query section, I assumed that you expect a PQ solution. In the attached file I've done what I believe you ...
No file was attached. Please try again and don't forget to push the "Start upload" button before you submit your reply.
If you are on a MS365 or in the web version, this formula could work (assume the blue table is called Table1): =BYROW(FILTER(Table1,Table1[Tasks]&l...
I believe the problem lies in the fact that you are trying to combine a stacked bar chart with a line chart on separate axes. If you can live with a s...
Hi Roy, That would be by adding a custom column with the following code: = Number.RoundDown([Actual Refill]/(1/6),0)*1/6) as demonstrated in ...
Glad I could help. Merry X-mas!
It's not a bug. PQ simply allows you to treat quoted line breaks in different ways. The default is to apply them, but in this case that's not what you...
Glad I could help you work out a solution. The pivot table format is dealt with in the Layout group of the Design ribbon that appears when you click a...
Here's another way. Perhaps even better to combine the Descriptions and Types into one column. See attached.