Forum Discussion

krish42's avatar
krish42
Frequent Visitor
6 months ago
Solved

DAX Query help

Hello,     I have 2 tables in the model 1. CUSTTRANS  RECID, ACCOUNTNUM, TANSDATE, AMOUNT, EXCHADJUSTMENT, TANSTYPE 2. CUSTSETTLEMENT TRANSRECID, TRANSDATE, EXCHADJUSTMENT, SETTLEAMOUNT 3. Cal...
  • krish42's avatar
    krish42
    5 months ago

    Thanks for the script.

    Though not exactly what I want but has given me an idea and I fixed the measure with RELATEDTABLE() function. Its giving the result and the performance is also good

Kedar_Pande's avatar
Kedar_Pande
Super User
5 months ago

krish42 

 

Result AmountMST = 
SUMX(
FILTER(CustTrans, CustTrans[TANSDATE] <= MAX('Calendar'[Date])),
VAR SettleAdj = RELATED(CustSettlements[EXCHADJUSTMENT])
RETURN
SWITCH(TRUE(),
CustTrans[TRANSTYPE] = 9, CustTrans[AMOUNTMST],
CustTrans[EXCHADJUSTMENT] = 0 && SettleAdj <> 0, CustTrans[AMOUNTMST] - SettleAdj,
CustTrans[AMOUNTMST] + CustTrans[EXCHADJUSTMENT]
)
)


If this answer helped, please click 👍 or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande

krish42's avatar
krish42
Frequent Visitor
5 months ago

Thanks for the script.

Though not exactly what I want but has given me an idea and I fixed the measure with RELATEDTABLE() function. Its giving the result and the performance is also good