Forum Discussion
How to dynamically total/count across multiple columns of a dynamic array
Hi, I'm trying to create a dynamic column that will give me a count based on two columns of a dynamic array. So if I've got three products across four offices like this... I want to sh...
I mentioned PivotTable only as comment to remind other options exist. For such case it doesn't require DAX and advanced data modelling skills. Refresh is a minus, more dynamic formatting is a plus.
Power Query here as easy as PivotTable, just two steps - query the source and GroupBy office/product. But it less common than PivotTable and also requires Refresh.
Spoilt for choice!!!
- Yes indeed many options!
I’m really using this as an excuse to get better with dynamic arrays so if I can learn to build this as a one formula table, that would be great.
I’d rather avoid pivot tables as I find them inflexible if you’re trying to use the output for another process.
The output for this will eventually populate a csv for a journal import.
Great responses - I’ll spend some time digesting and learning some of the functions I haven’t used yet.IMHO, spill, PivotTable in tabular form and structured table returned by Power Query will give exactly the same csv output. From that point of view no difference.
