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

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
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