Forum Discussion

bbbt123's avatar
bbbt123
Helper I
6 years ago
Solved

help with calculated column

Hello, I need help with a calculated column.   I have a table, call it "Table1" with unique values per category, see example below: category  value a 30 b 40 c 50   Then I have ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    I am thinking perhaps:

     

    Column in Table2 = 
  VAR __Category = [category]
  VAR __MinWeek = MINX(FILTER(ALL('Table2'),[category]=__Category),[week num])
RETURN
  IF([week num] = __MinWeek,LOOKUPVALUE('Table1'[value],'Table1'[category],__Category),BLANK())
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

I am thinking perhaps:

 

Column in Table2 = 
  VAR __Category = [category]
  VAR __MinWeek = MINX(FILTER(ALL('Table2'),[category]=__Category),[week num])
RETURN
  IF([week num] = __MinWeek,LOOKUPVALUE('Table1'[value],'Table1'[category],__Category),BLANK())