Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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/...
Need Help
  • hnguy71's avatar
    hnguy71
    7 years ago
    MyFriday = CALCULATE(MAX('Table'[Date]), FILTER('Table', 'Table'[Weeknum] = EARLIER('Table'[Weeknum]) && 'Table'[Day] = "Fri"))
hnguy71's avatar
hnguy71
Super User
7 years ago

Is this the result you are expecting?

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    hnguy71
    Super User
    7 years ago
    MyFriday = CALCULATE(MAX('Table'[Date]), FILTER('Table', 'Table'[Weeknum] = EARLIER('Table'[Weeknum]) && 'Table'[Day] = "Fri"))