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/5/2019 Mon

14/5/2019 Tue

15/5/2019 Thurs

16/5/2019 Fri

17/5/2019 sat

I expect as the following output:

Date Day Expected Output

12/5/2019 Sun 17/5/2019

13/5/2019 Mon 17/5/2019

14/5/2019 Tue 17/5/2019

15/5/2019 Wed 17/5/2019

16/5/2019 Thur 17/5/2019

17/5/2019 Fri 17/5/2019

18/5/2019 Sat 24/5/2019

19/5/2019 Sun 24/5/2019

20/5/2019 Mon 24/5/2019

21/5/2019 Tues 24/5/2019

22/5/2019 Wed 24/5/2019

23/5/2019 Thurs 24/5/2019

24/5/2019 Fri 24/5/2019

23/5/2019 Sat 24/5/2019

Using dax how can I achieve this one.

MyFriday = CALCULATE(MAX('Table'[Date]), FILTER('Table', 'Table'[Weeknum] = EARLIER('Table'[Weeknum]) && 'Table'[Day] = "Fri"))

Forum Discussion