Forum Discussion

marculos's avatar
marculos
Regular Visitor
7 years ago
Solved

New Table based on maxdate

Hi,    I am trying to create a table of unique product codes and latest date using "New table" in Power BI.  I need this so I can use the product code in a relationship.    So e.g ProductTable1  ...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    marculos Please try this as "New Table"

     

    ProductTableLatest = SUMMARIZE(Test12InputCalcTable,Test12InputCalcTable[Product],"Latest",MAX(Test12InputCalcTable[Date]))
AkhilAshok's avatar
AkhilAshok
Icon for Solution Sage rankSolution Sage
7 years ago

This should work:

ProductTableLatest =
SUMMARIZECOLUMNS (
    ProductTable1[SerialNumber],
    "LatestDate", MAX ( ProductTable1[ProductDate].[Date] )
)