Dates!!

[Anonymous]

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.

[hnguy71]

Is this the result you are expecting?

[Anonymous]

Thanks for your reply.  I have formed the weeknum column, could you please let me know how you created MyFriday column or attach Pbix file, it will be helpful for me

Regards,

Yuvaraj

[hnguy71 · Accepted solution]

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