Forum Discussion
Resolver ISum data by dates from 2 different tables
Create a calendar table and build relationship on date column with your existing tables.
Community ChampionAre these tables related to one another?
Resolver IGreg_Deckler, they are not related. However they have a common attribute (salesman). This value is not unique in any of those table but I have a salesman table so I could link both table through this salesman table.
Would that help?
- Greg_Deckler
Yes, if you link the tables then you could theoretically use the date column from either one of them, just depends on how you want to slice it.
- SuperSayan
I have linked the table in the below manner:
Table1[Salesman] n-->1 SalesmanTable[Salesman] 1<--n Table2[Salesman]
However, when I try to visualise my measure in an histogram by month, I get the same value for each month which is a clear indication that PowerBI doesn't know how to manage the date slicer.
Mesure is more or less the below:
SUMX(Table1, Table1[Price])+SUMX(Table2, Table2[Price])
v-chuncz-msftCommunity Support
Create a calendar table and build relationship on date column with your existing tables.