Forum Discussion

NipponSahore's avatar
NipponSahore
Icon for Resolver II rankResolver II
8 years ago
Solved

Many 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...
Need Help
  • NipponSahore's avatar
    NipponSahore
    8 years ago

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

NipponSahore's avatar
NipponSahore
Icon for Resolver II rankResolver II
8 years ago

Sorry, My Bad. It includes Customer 3

 

the total sale  will be for John Doe 2 146

NipponSahore's avatar
NipponSahore
Icon for Resolver II rankResolver II
8 years ago

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