Forum Discussion
Not able to join 2 tables using relationships. Values are getting aggregated from 2nd table
Hi Folks, I am trying to join Actual hours per category and forecast hours per category from 2 different tables. However, I am unable to do so. I used all the permuations and combinations. Actua...
Hi Anonymous ,
You can also try to create a new column:Column = LOOKUPVALUE(Table2[Forecast Hous],Table2[Date],Table1[Date],Table2[Service Category],Table1[Service Category],Table2[Territory Name],Table1[Territory Name])Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
V-lianl-msft
Community Support
Community SupportHi Anonymous ,
You can also try to create a new column:
Column = LOOKUPVALUE(Table2[Forecast Hous],Table2[Date],Table1[Date],Table2[Service Category],Table1[Service Category],Table2[Territory Name],Table1[Territory Name])
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.