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. This type of equation can be used to create a filter condition on a visual to only show items that are below the final depth (BleowFinalDepth = 1)
- 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
- BelowfinalDepth = if(samples[SampleTop]>samples[FinalDepth],1,0)
- Click the Tick box to the left of the formula bar to save the new field definition.