Forum Discussion
Need help with DAX
Dear All - I need your help in achieving the below requirement:-
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
- lbendlinSuper User
Your data model is not suitable. M:M relationships with bidirectional search will create ambiguities.
Correct your data model.