Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

get one table from another using join

Hi, I have a somewhat weird case that I'm trying to solve. Have a one-many relationship between two tables. I need one column from my many table into the other by using a calculated column. Would ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Figured this out by using this formula:

    CALCULATE(LASTNONBLANKVALUE(Table1[Column1], FIRSTNONBLANK(Table1[Column2], 1)))
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Figured this out by using this formula:

CALCULATE(LASTNONBLANKVALUE(Table1[Column1], FIRSTNONBLANK(Table1[Column2], 1)))