Forum Discussion
DoctorYSG
Helper III
1 year agoDAX DEFINE COLUMN
Can someone explain to me why one can define calculated columns in DAX studio, but not in the PowerBI DAX query tab? (It does not allow that syntax, only DEFINE MEASURE. See: DAX Queries - DAX | M...
- 1 year ago
Hi DoctorYSG
DEFINE COLUMN in DAX query view appears to work for me, but there an issue with Intellisense.
For example, this test query worked as expected for me:
DEFINE TABLE MyTable = {1,2,3} COLUMN MyTable[Value Squared] = MyTable[Value]^2 EVALUATE MyTableIf you run Performance analyzer on a visual containing a visual calculation then select Run in DAX query view, the query should also contain DEFINE COLUMN.