Forum Discussion
Dates!!
Hi, Below is the table I'm working on, to which I'm to add another column that will display the Friday's date of the week in all its rows. Date Day 12/5/2019 Sun 13/...
MyFriday = CALCULATE(MAX('Table'[Date]), FILTER('Table', 'Table'[Weeknum] = EARLIER('Table'[Weeknum]) && 'Table'[Day] = "Fri"))
Is this the result you are expecting?