Figure D Reference the data set to calculate commissions. Admittedly, in such a simple example, using Power Query seems like overkill. Initially, you don’t seem to be saving any time or effort.