Using DAX in Query Editor

[Anonymous]

Hi all,

I need help in writing this code in Query Editor.

I have created column in data section with below mentioned code:

MAX_ICE_ID = CALCULATE(MAX(TransactionDataTrackerHK021908[ICERecordID(ReadyPublish)]),FILTER(TransactionDataTrackerHK021908,TransactionDataTrackerHK021908[OriginalICERecordID(ReadyPublish)]=EARLIER(TransactionDataTrackerHK021908[ICERecordID(ReadyPublish)])))

However, I need the same logic in query editor, but above doesnt work in it.

Thank you

Abhijit

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

You can add a conditional column in Query Editor.

Power Query:

#"Added Conditional Column" = Table.AddColumn(#"PreviousStep", "Custom1", each if [#"ICERecordID(ReadyPublish)"] = [#"OriginalICERecordID(ReadyPublish)"] then [#"ICERecordID(ReadyPublish)"] else null)

Best regards,

Yuliana Gu

[rajulshah]

Hello @Anonymous,

You need to use M Query Language in Advance Editor.