Calculate End of week within customised string

[Anonymous]

I have a customised string that I want to include the end of the week date (Saturday) from a column I have [Event Date of first case]: 

e.g. measure

Title Table 1. = "Table 1: Contains all of my sample data " &
MAXX(ALL('Outbreaks and Events'),'Outbreaks and Events'[Event Date of first case]) &
" = "
& [Outbreak Identifier Count] //& MOD('Outbreaks and Events'[Event Date of first case])

In this case I have used MAXX(ALL('Outbreaks and Events'),'Outbreaks and Events'[Event Date of first case] to find the max of [Event Date of first case] but this goes too far and I need to just find the END OF THE WEEK (Saturday) for this column

Can this be done?

Thanks in advance

Maybe something like FORMAT(MOD)????

[mahoneypat · Accepted solution]

If this is for a calculated column, this expression can be adapted to get the end of the week (Saturday) date on each row.  You can concatenate it into your expression.

EOW Saturday = 'Date'[Date] + 7 - WEEKDAY('Date'[Date])

Regards,

Pat

[Fowmy]

@Anonymous 

Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn