top of page

Power Query Sheet

This worksheet helps you see the before and after that take place when data is transformed with power query.

Compatible with Excel

Color coding

Items in blue - inputs (editable)

Items in black - calculations (do not edit)

Items in purple - referencing another cell (do not edit)


  1. Update information in cells C2:D7




  • Hit Data > Refresh all to see the numbers change in columns G:I



  • To review the queries, hit Data > Queries & Connections, and double click Profit_and_Loss query.



Instructions

bottom of page