adding column with DAX in query editor

[Anonymous]

HI, Mr/Ms genius, 

I cannot add a column using DAX measure in query editor.

The DAX measure (below) is proven valid in normal data view, but I think you cannot add a column with DAX in Query Editor. Can someone help me translate this command of creating a new column into M? Or is there any other way around this?

DAX: 

IsLatestChangedDateByID = TableName[ChangedDate] = 
	CALCULATE(
		LASTNONBLANK(TableName[ChangedDate], 1), 
		FILTER(ALL(TableName), TableName[ID]=EARLIER(TableName[ID]))
	)

I need this column to be in Query editor for me to filter the table and merge with another table. 

Can someone help me pls? 

Many thanks, 

Zishu