Forum Discussion
NipponSahore
Resolver II
Resolver IIMany to many relationship - Type 2 data from CSV
[ Spoiler ] Hi All, Im facing the issue creating an appropiate data model for my 2 report requirements. The 2 CSV files are is like the following format. Sales Sales ID Cu...
Also, Thank you to the community,
I was able to find an answer somewhere else, but anyone is still looking for the answer here,
I created a calculated column "Employee_Sold" and used 2 variables to join and find the answer
Employee_Sold =>
var thisdate = SALES[date] var thisterritory = SALES[customer] return CALCULATE(FIRSTNONBLANK(FieldDetails[Employee],0),FILTER(all(FieldDetails),FieldDetails[Valid from] < thisdate && thisdate <FieldDetails[Valid to] && thisterritory = FieldDetails[customer]))
NipponSahoreResolver II
Resolver IIHi Greg,
As this record is present in field details table but a sales entry is missing.
my major concern is how can relate the two data sources which have many to many relationship and solve the issue of issue of where I can use one slicer and be ae to select all past and present sales made for one customer by multiple employees
As this record is present in field details table but a sales entry is missing.
my major concern is how can relate the two data sources which have many to many relationship and solve the issue of issue of where I can use one slicer and be ae to select all past and present sales made for one customer by multiple employees
Greg_Deckler
Community Champion
Community ChampionTo solve many-to-many, create a bridge table of unique ID's and relate that table to both of your other tables. Use your bridge table in your slicer.