cancel
Showing results for
Did you mean:
Member

## 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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Member

## Re: Dates!!

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

## Re: Dates!!

Is this the result you are expecting?

Member

## Re: Dates!!

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

Highlighted
Member

## Re: Dates!!

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