cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yuvarajg Member
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
hnguy71 Member
Member

Re: Dates!!

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

Re: Dates!!

Is this the result you are expecting?

 

result_date.png

yuvarajg Member
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
hnguy71 Member
Member

Re: Dates!!

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