Forum Discussion

redhughes's avatar
redhughes
Helper II
7 years ago
Solved

MAX 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 addedWeek commencingValue
29/07/201929/07/201910
29/07/201905/08/201920
29/07/201912/08/201950
01/08/201929/07/201920
01/08/201905/08/201940
01/08/201912/08/2019100

 

So in this example the first line should have a max Date added of 01/08/2019. What's the best way of doing it - Query Editor or adding a new column to the table, and what formulas/functions can I use? thanks a lot for your help!

Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi redhughes 

    If you want to add a new column to the table:

     

    NewColumn =
CALCULATE (
    MAX ( Table1[Date added] ),
    ALLEXCEPT ( Table1, Table1[Week commencing] )
)

     

     

2 Replies

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi redhughes 

    If you want to add a new column to the table:

     

    NewColumn =
CALCULATE (
    MAX ( Table1[Date added] ),
    ALLEXCEPT ( Table1, Table1[Week commencing] )
)