New Measures in PowerQuery

Yesterday we learnt about the 'New Measure' feature in PowerBI to create new fields in desktop, rather than in PowerQuery. Here you can use DAX (the coding language used in PowerBI) to create a simple calculated field which can be used as a measure in your chart or as part of a slicer.

Follow along with this example using Superstore Sales data.

Firstly, click on your table (in my case the Orders table) in the 'Data' pane and find 'Table tools' >> 'New Measure'.

In the field below the header you can enter your DAX calculation:

Total Sales = SUM(Orders[Sales])

where

Column name = FUNCTION(Table Name[Field])

Congrats, now you've created your first DAX calculation! 😄

Author:
Hewan Zewdu
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab