Forum Discussion
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 ...
marculos Please try this as "New Table"
ProductTableLatest = SUMMARIZE(Test12InputCalcTable,Test12InputCalcTable[Product],"Latest",MAX(Test12InputCalcTable[Date]))
marculos Please try this as "New Table"
ProductTableLatest = SUMMARIZE(Test12InputCalcTable,Test12InputCalcTable[Product],"Latest",MAX(Test12InputCalcTable[Date]))
wow you guys are fast! many thanks for all your help :) :)