Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Using DAX in Query Editor

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[ICERecord...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hello Anonymous,

 

You need to use M Query Language in Advance Editor.