Forum Discussion

AmyM-NirR's avatar
AmyM-NirR
Copper Contributor
May 01, 2023
Solved

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...
  • Riny_van_Eekelen's avatar
    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.

Resources