- If you are creating new measures or calculated columns, the language is DAX. But if you’re making a new custom column from the Query Editor, that will be using M instead of DAX.
- Columns can be created either in the Query Editor or the normal window
- Technical differences are explained here: https://www.sqlbi.com/articles/comparing-dax-calculated-columns-with-power-query-computed-columns/
- Measures can be created in the normal window.
- Note: For most of my calculated measures, I included a “+0” on the end of the calculation. This was so that instead of showing blank cells in a table, PBI would display the 0 value instead. This has the potential to cause issues when used later, especially when dealing with different data types.