Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

IF formula with multiple conditions

I have 2 tables and 1 country table which is used to create relationship between them (even other tables linked to country table). Now i need to check if Amt is available in Table1 for the same coun...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Anonymous  Please try this as a New Table (below logic uses your table 1 as lookup and table 2 as base table)

     

    Test297Out = 
VAR _Table = SUMMARIZE(Test297Main,[Region],"Amt",SUM(Test297Main[Amt]))
RETURN ADDCOLUMNS(_Table,"DivideAmount",DIVIDE([Amt],LOOKUPVALUE(Test297Lkp[Amt],Test297Lkp[Region],Test297Main[Region])))

     

     

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous  Please try this as a New Table (below logic uses your table 1 as lookup and table 2 as base table)

 

Test297Out = 
VAR _Table = SUMMARIZE(Test297Main,[Region],"Amt",SUM(Test297Main[Amt]))
RETURN ADDCOLUMNS(_Table,"DivideAmount",DIVIDE([Amt],LOOKUPVALUE(Test297Lkp[Amt],Test297Lkp[Region],Test297Main[Region])))