Creating Power BI Fields and Columns | CLEARIFY

Adding Your Own Fields and Columns

QQube provides hundreds of natively constructed calculated columns - as well as several hundred additional PowerBI calculated columns. But there will be times you will need your own columns to represent the data the way you want to see it.

PowerBI provides two types of additional columns:

• Calculated Column which consists of a formula that is evaluated row by row, such as one column minus another or the first "x" characters of an item.
• Measure (or Calculated Field) which contains an aggregate calculation such as the sum or average of a column.

Calculated Columns

Let's say that the first two characters of an item in QuickBooks represent the manufacturer.  You could add a column for this, and create a formula that parses the left two characters of an item name string.

The formula in this case is left('Item'[Item Name],2) 

Measures (Calculated Field)

You can open up any detail Power BI example from the QQube Configuration Tool, and see dozens of examples (over 200 Measures in all).

The examples contain aggregations of varying types.

Writing Formulas for Measures

PowerBI provides two avenues for creating Measures:

• Traditional (Manual Entry)
• Quick Measure (Wizard Based)

Microsoft provides several tutorials:

• Calculated Columns
• Measures