Offset - Profitbase/PowerBI-visuals-FinancialReportingMatrix GitHub Wiki

With Add Column Formula or Add Measure, you get a formula field. In this, you can now use the Offset function.

Goal: Add a measure that compares current month against last month.

Steps:

  1. Right click a column in February (as we need a value for the period before, which January does not have in this view) image

  2. Click on a value in the Actuals column under February to get the current value.

  3. Hold the Shift-key while clicking a value in the Actuals column under January. The orange arrow in February indicates this is the starting point for the formula. Any Offsets will be decided based on it's position relative to the orange arrow: Clicking January while holding the Shift-key will be (offset-1), while clicking March will be (offset+1). image

The offset function works with any field you add to the Column header, not only Months or years.