Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Join two tables repeating rows

So, I think it's a simple problme, but I can't resolve it on time.   I have a table A with two columns: Employee and Code. And table two with two columns too: Code and Course.   Table 1: ...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    NewTable=GENERATE(Table1,CALCUATETABLE(VALUES(Table2[Course]),TREATAS(VALUES(Table1[Code]),Table2[Code])))

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

NewTable=GENERATE(Table1,CALCUATETABLE(VALUES(Table2[Course]),TREATAS(VALUES(Table1[Code]),Table2[Code])))

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    It works. Thank you!!