Forum

Hi Prorok, You can do everything via user interface functions. I would go for Grouping, List.Combine, then Pivot the Index 4 column, last 4 step...

Hi Blanka, Interesting challenge 🙂 Cash should be in a separate table, otherwise it will make thinks more complicate than it should be. We mana...

Hi Jose, It's not an endless loop, it's limited to the number of pivots from that sheet, but will loop though all slicercaches and its slicers from...

Hi Raj, What version of excel are you using? If you have the Proffesional Plus version of office, you can use the workbook Compare tools from th...

Hi Jose, To connect all slicers to all pivot tables from a specific sheet, you can use this code (change the targetsheet name as needed, it's set t...

Hi Peter, You can add a new column: = Table.AddColumn(Source, "Custom", each List.Count(Splitter.SplitTextByAnyDelimiter(Table2[Keywords])([Colu...

Hi, You seem to go into a wrong direction, there is no need to update the source range using codes, if you use a defined name to dynamically identi...

Hi Graham, Try this version: =MATCH(TRUE,INDEX(INDIRECT($N$1&ROW(),1):INDEX(INDIRECT($O$1&ROW()),1)="-",0))

Ok, I guess you're referring to range C50:T102 as "the chart". Are you trying to say that this formula used in the above range is not working as ex...

You can try moving the tables into another column, by adding another column with this formula: =if Value.Is([ColumnName],type table)=true then [Col...

Hi Cheryl, Each case is different and needs different solutions. Can you upload a sample xml file?

Hi Daniel, What do you mean by "chart"? You said that: "workers who start at 11 PM and finish at 7 AM don't appear at all in my chart", but ther...

Ok, this means you managed to solve the problem, sounds great.

What should I do with the link you provided? It does not provide access to links or queries.

Hi Julian, The file is no longer available, can you please resend a link?