Get the MAX date for a particular filtered table

[milomilo2020]

Hello, I have this table:

Columns: LastWeekDay, Date

I need to create a column that brings the MAX LastWeekDay based on the applied filters. For example, If I have two weeks selected and the MAX Week is 23/12/2022, then the new column will show for every row, 23/12/2022

How can I achieve this in DAX?

Thanks

[speedramps]

Polite reminder.

Remeber we are unpaid volunteers.

Click the thumbs up and accept as solution button. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !

[CNENFRNL]

[milomilo2020]

Thanks for the quick response, let me share the logic: 

I have a calendar date with the following columns:

LastWeekDay	Date
30/12/2022	24/12/2022
30/12/2022	25/12/2022
30/12/2022	26/12/2022
30/12/2022	27/12/2022
30/12/2022	28/12/2022
30/12/2022	29/12/2022
30/12/2022	30/12/2022
23/12/2022	17/12/2022
23/12/2022	18/12/2022
23/12/2022	19/12/2022
23/12/2022	20/12/2022
23/12/2022	21/12/2022
23/12/2022	22/12/2022
23/12/2022	23/12/2022

I need to have a chart with the latest 4 weeks, depending on the Filter applied to the Date column. So, for example, for one particular measure, I need to show in a line chart, that measure evolution the last 4 LastWeekDay depending on the filter applied.

[speedramps]

We want to help.

Please can you explain what you are trying to do.

Provide examples of your input dat (as tabels not screen shots)

and examples of the desired output

with a clear description of the steps.

Make sure you use the same fieldnames for input, output and the description so we understand you. 

Are you trying to get the start of week and end of week for each Date ?

That can be better done in Power Query 

https://docs.microsoft.com/en-us/powerquery-m/date-startofweek

https://docs.microsoft.com/en-us/powerquery-m/date-endofweek