Forum Discussion
Help with a calculated column (lookup function?)
Good morning, I have a table (Product_Structure) that contains repeat part number combinations (Parent Part + Child Part) because it esentially keeps a log of all the times the part number pairi...
you can try this
Column = if( CALCULATE(max('Table'[creation date]),ALLEXCEPT('Table','Table'[parent part],'Table'[child part]))='Table'[creation date],1,0)