Conditional column for dates

[Syndicate_Admin]

Hello people!

I would like your help with a DAX formula for this situation shown in the image:

I have in column 1 where there are random dates from 2021 to today and counting...
In the second column I gave an example of the expected result where, for example, all dates that are between July 01 and 31, 2022 in column 1, in column 2 must be 31-07-2022.

This should be in one column and not in another table.

Greetings and thanks in advance!

[rsbin · Accepted solution]

@Syndicate_Admin ,

If I understand your requirement, I believe the ENDOFMONTH function best suits your needs:

Fecha 2 = ENDOFMONTH([Fecha 1])  

Trust this works for you.

Regards,