DAX DEFINE COLUMN

Confirmed. It is an intellisense bug, not a DAX limitation of the Query Tab. Any chance we can submit a bug and get it this fixed?

OwenAuger 

I am tryhing to use the DAX query view to Run a query that Defines a COLUMN (and I would like to do that for TABLE as well). I understand that I will get intellisence sytnax flagging, but this one is giving errors about end of input. Any ideas if this is possible?

( I really need the VAR for clarity).

DEFINE
	COLUMN
		'Traces'[zResponseTime] =
		VAR CurrentApp = 'Traces'[AppName]
		VAR CurrentVersion = 'Traces'[AppVersion]
		VAR CurrentBase = 'Traces'[BaseCode]
		VAR CurrentDevice = 'Traces'[DeviceName]
		VAR CurrentUser = 'Traces'[UserName]
		VAR CurrentResponseTime = 'Traces'[ResponseTime]
		VAR CurrentActivity = 'Traces'[ActivityName]

		VAR mean =
		CALCULATE(
			AVERAGE('Traces'[ResponseTime]),
			FILTER(
				'Traces',
				'Traces'[AppName] = CurrentApp &&
				'Traces'[AppVersion] = CurrentVersion &&
				'Traces'[BaseCode] = CurrentBase &&
				'Traces'[DeviceName] = CurrentDevice &&
				'Traces'[UserName] = CurrentUser &&
				'Traces'[ActivityName] = CurrentActivity
			)
		)

		VAR std =
		CALCULATE(
			STDEV.P('Traces'[ResponseTime]),
			FILTER(
				'Traces',
				'Traces'[AppName] = CurrentApp &&
				'Traces'[AppVersion] = CurrentVersion &&
				'Traces'[BaseCode] = CurrentBase &&
				'Traces'[DeviceName] = CurrentDevice &&
				'Traces'[UserName] = CurrentUser &&
				'Traces'[ActivityName] = CurrentActivity
			)
		)

		RETURN
			DIVIDE(
				CurrentResponseTime - mean,
				std,
				0
			)

It would be really nice to be able to testing things out in query view, and get TABLEs and COLUMNS added to the model. (as one can do with measures). I have DAX studio, but I suspect is it read one to the SSAS.