Apr 30 2023 09:53 PM
The picture above shows my data after I've performed some manipulations on it in PQ.
The data is after a "Pivot Column" step is aggregated as maximum ,and it represents the maximum number of fruits at certain time periods (each letter represents a time period, i.e. B1, C1 etc).
Unfortunately, I can't know upfront which fruits or which time periods are going to be in the data, so it has to be completely dynamic.
I'll be glad for some ideas how to approach this issue...
Thanks!
Apr 30 2023 10:33 PM - edited Apr 30 2023 11:13 PM
Solution@AmyM-NirR Please find solutions for both in the attached file.
Re 1) I recently picked-up a technique to do this on the microsoft.answers forum. You'll find the link in the file.
Re 2) I came up with a rather simple, all GUI (i.e. no M-coding), solution. See if it works for you.
Apr 30 2023 11:08 PM
Another Power Query option attached