Add custom columns - Profitbase/PowerBI-visuals-FinancialReportingMatrix GitHub Wiki

#Premium feature

Custom columns enable report authors to easily add calculated columns to a report without having to edit the data model or create complex DAX queries.

  1. Ensure you are in Edit mode
  2. Right click any column (header) and choose “Add column before” or “Add column after”.
  3. Specify the Header and the formula. You specify the formula by ensuring that the Formula bar has focus, and then click the columns to include in the calculation. The visual will automatically add the “+” operator, but you can change it to -, * or / (minus, multiply or divide) at any time.

[!TIP] Hold Ctrl while clicking a cell to insert an absolute reference (e.g. $(Actual).$(Sales)) instead of a relative one. Use absolute references when the formula should always point to that specific column/row, regardless of the row or column context in which the formula is evaluated.

Step 1
Step 1

Step 2
Step 1

Step 3
Step 1