Forum Discussion

gauravnarchal's avatar
gauravnarchal
Post Prodigy
4 years ago

Need help with DAX

Dear All -  I need your help in achieving the below requirement:-

 

Sample Data PBIX

 

Requirement

If the Invoice number starts with “9”

ð NI Receipts (Authentication Response) is “SUCCESS” & NI Receipts (Order Status) is “CLOSE”

Then Match

ð Receipts (Auth Code) = NI Receipts (Capture Code) & Receipts (Cash Amount) = NI Receipts (Refund Amount)

Return “PASS” else “FAIL”

 

If the Invoice number starts other than “9”

ð NI Receipts (Authentication Response) is “SUCCESS” & NI Receipts (Order Status) is “CLOSE”

Then Match

ð Receipts (Auth Code) = NI Receipts (Capture Code) & Receipts (Cash Amount) = NI Receipts (Capture Amount)

Return “PASS” else “FAIL”

 

 

1 Reply

  • Your data model is not suitable.  M:M relationships with bidirectional search will create ambiguities.

    Correct your data model.