Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Combining Summarize and Lookupvalue

Hi,   Im struggling with the following, any help is much appreciated. I have a table called "Product" with information and a newly created Table called "Information" where some of the information f...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Perhaps:

     

    New Table = 
    SUMMARIZE(
      FILTER('Table',[Product Type] = "Bike"),
      [Name],
      "Amount",SUM('Table'[Amount])
    )
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Perhaps:

 

New Table = 
    SUMMARIZE(
      FILTER('Table',[Product Type] = "Bike"),
      [Name],
      "Amount",SUM('Table'[Amount])
    )