cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Re: Many to many relationship - Type 2 data from CSV

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]))

Highlighted
Super User
Super User

Re: Many to many relationship - Type 2 data from CSV

Hi,

 

You may refer to my solution here.

 

Hope this helps.

 

Untitled.png