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[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

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

2 Replies

  • 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.

  • 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