DAX to Power Query Lookup value

Power Query
1

Hello EDNA - some GURU help would be apperciated. looking to convert a working DAX calculated column to Power Query. looks like I need this before an append query.

here’s the WORKING Dax Code:

Rate2 = 
MAXX (
    FILTER (
        EquipRates,
        EquipRates[EquipType] = Data[Name / EquipType]
            && Data[Tdate] >= EquipRates[DateStart]
            && Data[Tdate] <= EquipRates[DateEnd]
    ),
    EquipRates[Rate]
)

Thank you in advance,

Frankee

2

Hi @Frankee,

Don’t think that will be a problem.But you know the drill.
Share a PBIX with dummy data as well as an XLSX. Dont forget to include the expected outcome.

Cheers!

3

Hello @Melissa - thanks for the reply …I got you.

here are the files. the desired result is in the PBI file…DATA table. Rate2 column, see pic

image
image508×573 14 KB

Resolved with these two posts:

https://techcommunity.microsoft.com/t5/excel/power-query-lookup-value-between-dates-in-a-separate-table/m-p/3660435?attachment-id=56291

and

nested if

Thanks Again,

Frankee