Forum Discussion
Not able to join 2 tables using relationships. Values are getting aggregated from 2nd table
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.
Super UserAnonymous , You need to join both these tables with common dimensions like
Service Category, Territory Name and Date
and analyze them with help from common dimension
Common table
Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos. star schema
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema