DAX: Return a date value from a column that is closest to another date value from a row

[mpicca13]

Little stuck with this one.

I need to return the closest date value from [Last Pay Period Paycheck Column] that is <= the value within each row from column [End of Next Month]

Example: [End of Next Month] = 2/29/2020

                The closest date value in [Last Pay Period Paycheck Date] that is <= 2/29/2020 woud be 2/28/2020:

               Expected Result would be:      [Test] = 2/28/2020

See Image below for reference and current outputs:

[edhans · Accepted solution]

Is this what you need? It is a calculated column. You didnt' specify but you are showing a table.

Test = 
VAR NextMonthDate = 'Table'[End of Next Month]
RETURN
MAXX(
    FILTER(
        'Table',
        'Table'[Last Payperiod Check Date] <= NextMonthDate
    ),'Table'[Last Payperiod Check Date]
)

If not, can you post some actual data with expected results using the directions below?

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum

[mpicca13]

That is exactly what I needed, thank you sir!

[edhans]

Excellent @mpicca13 

Glad to help out!