In order to help structure your PowerBI model in a way that is easy to use, it is recommended that all the measures are stored within the same table. In order to do this you'll need to create a new table for your measures. There are a couple of ways to do this, the easiest way is to create a new table using DAX which contains a single, blank column. The instructions below describe the process required to create this table.
- Open PowerBI
- In the menu bar, click on 'Modelling'
- Click on 'New Table'
- This will display the formula bar with 'Table = ' entered
- Chance the word Table to MeasuresTable and enter the text {Blank()} after the equals sign so it looks as shown here
- Hit Enter. On the right hand side of the screen you'll now see the table and a single measure
- To add more measures, hover on the new table until the ellipsis (three dots) appears
- Click on the ellipsis and then click on 'New Measure'
- Type the new measure in the formula bar once the new measure is shown (as below)
- This example will create a random number
- Hit enter and you're done
Comments
Post a Comment