redhughesHelper II7 years agoSolvedMAX date IF I have a table with "Date added" and "Week commencing", and I'd like to find the max Date added for each Week commencing: Date added Week commencing Value 29/07/2019 29/07/2019 10 29...Show MoreAlB7 years agoHi redhughes If you want to add a new column to the table: NewColumn = CALCULATE ( MAX ( Table1[Date added] ), ALLEXCEPT ( Table1, Table1[Week commencing] ) )
AlB7 years agoHi redhughes If you want to add a new column to the table: NewColumn = CALCULATE ( MAX ( Table1[Date added] ), ALLEXCEPT ( Table1, Table1[Week commencing] ) )
AlB7 years agoHi redhughes If you want to add a new column to the table: NewColumn = CALCULATE ( MAX ( Table1[Date added] ), ALLEXCEPT ( Table1, Table1[Week commencing] ) )
AlBCommunity Champion7 years agoHi redhughes If you want to add a new column to the table: NewColumn = CALCULATE ( MAX ( Table1[Date added] ), ALLEXCEPT ( Table1, Table1[Week commencing] ) )
