Creating new columns

New columns can be created in a Power BI report to help you with filtering or joining data tables together.

To create a new Column follow the steps below

• Open the data view by clicking on the data view icon on the lefthand side of the screen and then selecting the required data table from the right-hand list.

• Click the Table Tools menu item and select New Column Icon from the Ribbon
• The new column can then be defined by an equation in the formula bar above the table, as shown below. The syntax of the formula is FieldName = Excelstyle Equation.  Some examples are shown below
  • BelowfinalDepth = if(samples[SampleTop]>samples[FinalDepth],1,0)
    • Create a field called BelowFinalDepth and set its value to 1 if the sampleTop of this row is greater than the finalDepth value of this row.
  • SampleKeyFields = samples[LocationID]& samples[SampleTop]& samples[SampleType] & samples[SampleReference]
    • Create a field called SampleKeyFields that joins together the values for the Key Fields. This is an important equation for joining tables together

• Click the Tick box to the left of the formula bar to save the new field definition.