Forum Discussion

leilei787's avatar
leilei787
Helper II
4 years ago
Solved

Question about lookup function in PBI

Hi everyone, i have a question about lookup in PBI, please help   i am working on a PBI project related to customer product penetration.    Below are three tables. The first table represents cus...
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    leilei787 Try something like this:

    Total Addressable market column = 
  VAR __Customer = [Customer ID]
  VAR __Date = [Order Date]
  VAR __MinDate = MINX(FILTER('1st Table',[Customer ID] = __Customer),[Order Date])
RETURN
  IF(__Date = __MinDate,MAXX(FILTER('2nd Table',[Customer ID] = __Customer),[Total Addressable market]),BLANK())
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

leilei787 Try something like this:

Total Addressable market column = 
  VAR __Customer = [Customer ID]
  VAR __Date = [Order Date]
  VAR __MinDate = MINX(FILTER('1st Table',[Customer ID] = __Customer),[Order Date])
RETURN
  IF(__Date = __MinDate,MAXX(FILTER('2nd Table',[Customer ID] = __Customer),[Total Addressable market]),BLANK())