Forum Discussion
AmyM-NirR
May 01, 2023Copper Contributor
Subtracting two queries in Power Query
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 f...
- May 01, 2023
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.
Lorenzo
May 01, 2023Silver Contributor
Another Power Query option attached